Re: Query optimization question
Posted by:
Rick James
Date: February 28, 2009 04:03PM
It would help to know what the indexes are. Please provide
* SHOW CREATE TABLE tbl\G
* SHOW TABLE STATUS LIKE 'tbl'\G
and surround them with [ code ] and [ / code ]
It is curious that the index 'ix_totalsum' seems to be 1 byte??
Subject
Written By
Posted
February 27, 2009 04:34PM
February 28, 2009 06:36AM
Re: Query optimization question
February 28, 2009 04:03PM
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.