Hi,

Thanks for the tips, however it doesen't seem to help:

To clarify: I get the desired result using where PK='unreachable' and EXPLAIN PLAN says that an INDEX RANGE SCAN is performed

When I use where 1=0 and ROWNUM < 1, EXPLAIN PLAN says that a FULL TABLE SCAN is performed (which of course is associated with a cost...)

What I want is for Oracle to immediatle shortcut and return the answer without having to scan the table at all. Is this possible?

And sorry, I haven't been in Singapore.

Thanks