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
2983
August 14, 2012 01:06PM
1458
August 15, 2012 02:46AM
Re: Query with GROUP BY not using Index
1359
August 16, 2012 10:30AM
1634
August 17, 2012 02:58AM
1357
August 18, 2012 10:30PM
1321
August 24, 2012 12:41PM
1386
August 28, 2012 03:11AM
1451
August 28, 2012 06:21PM
1818
August 29, 2012 01:28AM
1275
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.