Re: Slow Query for Alphabetically Adjacent Terms
Posted by:
Rick James
Date: March 30, 2010 10:02PM
I suspect the 'prefix' is preventing a sensible query plan. It seems to be scanning the whole table since it cannot trust the index to be in order. Yet another graphic example of why 'prefix indexes' should be avoided.
Did you time my other two suggestions?
Please use [ code ] and [ / code ] (without spaces) around things to preserve spacing.
Subject
Written By
Posted
Re: Slow Query for Alphabetically Adjacent Terms
March 30, 2010 10:02PM
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.