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
3242
July 07, 2011 02:14AM
899
July 07, 2011 06:39AM
1092
July 07, 2011 09:47AM
1006
July 07, 2011 01:10PM
889
July 07, 2011 10:29PM
1144
July 08, 2011 06:52AM
1842
July 08, 2011 07:03AM
941
July 08, 2011 09:07PM
993
July 09, 2011 07:16AM
1024
July 09, 2011 10:49AM
971
July 09, 2011 01:09PM
1236
July 09, 2011 04:54PM
888
July 10, 2011 01:59AM
Re: Time performance in query Inner Join
851
July 10, 2011 12:19PM
1714
July 10, 2011 01:55PM
944
July 10, 2011 04:28PM
942
July 11, 2011 03:01AM
999
July 11, 2011 11:28AM
838
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.