Re: What index access path does INDEX_SS yield ?

Spendius wrote:
> Hi,
> I have a query where the skip scan hint keeps the optimiser
> choosing an index full scan: will the use of this hint always
> have this effect ? This is a 10g DB.
>
> Thanks.
> Spendius

Generic questions without any details as to the specific statement, without running the statement with event 100053 set: it is always the same with you, isn't it?
Do you really think such sweeping generic answers are possible? If not, why do you continue to post questions without any information? Or are you just searching for silver bullets? Hints are just what they are: HINTS.
There must be a specific reason why CBO choose to ignore the hint. Set event 10053 (as explained here many times before) and find out the reason.

-- 
Sybrand Bakker
Senior Oracle DBA