Time performance in query Inner Join
Hi there, I need your appreciated help.
I try execute query inner join in the two tables in mysql:
tbl_a = 9.290 records
tbl_b = 3.665.958 records
The query working but the time execution is over 5 minutes.
All fields is indexed in the tables.
I can how decrease the time performance ?
I think about temporary table, but is expected in mysql? Any examples?
Can you help me?
Thanks in advance-
Edited 2 time(s). Last edit at 07/07/2011 02:28AM by angel rivero.
Subject
Views
Written By
Posted
Time performance in query Inner Join
3255
July 07, 2011 02:14AM
903
July 07, 2011 06:39AM
1098
July 07, 2011 09:47AM
1010
July 07, 2011 01:10PM
894
July 07, 2011 10:29PM
1148
July 08, 2011 06:52AM
1849
July 08, 2011 07:03AM
947
July 08, 2011 09:07PM
999
July 09, 2011 07:16AM
1030
July 09, 2011 10:49AM
976
July 09, 2011 01:09PM
1242
July 09, 2011 04:54PM
891
July 10, 2011 01:59AM
855
July 10, 2011 12:19PM
1721
July 10, 2011 01:55PM
954
July 10, 2011 04:28PM
951
July 11, 2011 03:01AM
1003
July 11, 2011 11:28AM
845
July 12, 2011 10:22AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.