Re: Time performance in query Inner Join
We are 13 messages into this thread, and I still don't have all the information needed to analyze your problem. The EXPLAIN does not match the one SELECT you have shown.
Please provide ALL of these in a SINGLE message for this thread:
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
Subject
Views
Written By
Posted
3258
July 07, 2011 02:14AM
903
July 07, 2011 06:39AM
1099
July 07, 2011 09:47AM
1010
July 07, 2011 01:10PM
894
July 07, 2011 10:29PM
1149
July 08, 2011 06:52AM
1849
July 08, 2011 07:03AM
947
July 08, 2011 09:07PM
999
July 09, 2011 07:16AM
1031
July 09, 2011 10:49AM
977
July 09, 2011 01:09PM
1243
July 09, 2011 04:54PM
891
July 10, 2011 01:59AM
Re: Time performance in query Inner Join
855
July 10, 2011 12:19PM
1723
July 10, 2011 01:55PM
955
July 10, 2011 04:28PM
951
July 11, 2011 03:01AM
1004
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.