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

Home -> Community -> Usenet -> c.d.o.server -> Re: What index access path does INDEX_SS yield ?

Re: What index access path does INDEX_SS yield ?

From: Spendius <spendius_at_muchomail.com>
Date: 5 Jan 2007 01:02:42 -0800
Message-ID: <1167987762.297453.226570@11g2000cwr.googlegroups.com>


> Do you have any hints AFTER the index_ss() ?
No.

> What's the exact list of hints as it appears in
> your query ?

INDEX_SS is the only one, I would've detailed them if there had been more; anyway I've created an index on this specific field to get rid of both these FTS and FULL INDEX SCAN accesses.

Thanks. Received on Fri Jan 05 2007 - 03:02:42 CST

Original text of this message

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