Re: Index evaluation
Your txt column is a TEXT type, you only index the first 250 characters.
Even though it could work but probably the optimiser is not smart enough to detect that. Maybe submit a feature request.
Try change that to a varchar and index the whole column and see if it makes any difference.
Subject
Views
Written By
Posted
3299
July 23, 2007 04:51PM
2282
July 23, 2007 05:18PM
Re: Index evaluation
2239
July 24, 2007 02:06AM
2239
July 24, 2007 04:33AM
2266
July 23, 2007 07:27PM
2222
July 24, 2007 05:24AM
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.