Duh! sound of hand smacking forehead
I didn't notice that there was no cost listed next to the COST=
You're absolutely right. Of course a hint can still be used to change to
COST, but certainly in this query it seems unlikely to be worthwhile unless
there is a large %age of rows being returned
He works with rule based optimizer (cost= in explain plan). Maybe using
choose ad not analyzing. So it does not matter how values distributed -
if index exist rule based optimizer will use it.
Alex Hillman
-Original Message-
Sent: Wednesday, May 16, 2001 6:16 PM
To: Multiple
Hi all,
I know how to generate the query plan but how to
interplate the query plan, really? The only thing I
know is if there is a FULL TABLE SCAN, that most
probably is bad, need to build an index. However, if
the query plan shows me something else, I don't know
what to improve.
For example,