Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Forcing use of an index

Re: Forcing use of an index

From: Karen Abgarian via DBMonster.com <forum_at_DBMonster.com>
Date: Thu, 24 Mar 2005 00:08:45 GMT
Message-ID: <7bea223607374b2fb9fd6540600b88ee@DBMonster.com>


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
Received on Wed Mar 23 2005 - 18:08:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US