Re: Forcing use of an index

Hi,

I think you should define better the line "can be anywhere in the column". What precedes the data?
If you can identify some rule for that, you may just create another column (f.e. automatically with a trigger) and just have the value there that can be indexed.

If you have to have this structure, there is really little you can do. You can, though, somewhat reduce the problem if an index on this column is smaller, by putting a hint to use the index. Your best bet is probably INDEX_FFS. That is going to do a similar to a full table scan, but on the index.

TxRs

-- 
Message posted via http://www.dbmonster.com