Re: Query with GROUP BY not using Index
Hi Øystein,
thanks for the suggestion. The text field is 256 characters long, so the index of size 255 shouldn't be a prefix, should it? I tried to re-create the indexes without an explicit size, as you suggested:
ALTER TABLE `epi_iv` DROP INDEX `wafer_name`, ADD INDEX `wafer_name` (`wafer_name`)
ALTER TABLE `epi_iv` DROP INDEX `wafer_name_date`, ADD INDEX `wafer_name_date` (`wafer_name`,`date`)
but the wafer_name indexes still have size 255, and the query hasn't improved its speed as it's still not using the composite index.
Any other ideas?
imran
Subject
Views
Written By
Posted
3082
August 14, 2012 01:06PM
1553
August 15, 2012 02:46AM
Re: Query with GROUP BY not using Index
1421
August 16, 2012 10:30AM
1713
August 17, 2012 02:58AM
1424
August 18, 2012 10:30PM
1391
August 24, 2012 12:41PM
1460
August 28, 2012 03:11AM
1525
August 28, 2012 06:21PM
1889
August 29, 2012 01:28AM
1342
August 29, 2012 10:36AM
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.