I believe I heard that when you "select ssn from employees" and ssn is
indexed, that oracle may use the index, if the column(s) are contained in
the index. Further, I know you can give a hint to "suggest" it use the
index. But it doesn't sound like a good idea to write production code
relying on this because someone can change the optimizer (delete stats) or
drop the index. Is there a way to "force" oracle to use the index, or
return an error if it can't for some reason? Thanks.
Received on Sun Jul 04 1999 - 09:25:06 CDT
