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
3252
July 07, 2011 02:14AM
902
July 07, 2011 06:39AM
1097
July 07, 2011 09:47AM
1008
July 07, 2011 01:10PM
893
July 07, 2011 10:29PM
1146
July 08, 2011 06:52AM
1848
July 08, 2011 07:03AM
946
July 08, 2011 09:07PM
997
July 09, 2011 07:16AM
1029
July 09, 2011 10:49AM
974
July 09, 2011 01:09PM
1239
July 09, 2011 04:54PM
890
July 10, 2011 01:59AM
853
July 10, 2011 12:19PM
1719
July 10, 2011 01:55PM
951
July 10, 2011 04:28PM
944
July 11, 2011 03:01AM
1002
July 11, 2011 11:28AM
843
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.