Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index Range Scans....
Good eyes, Robert. Failure to include all join keys is a common error
that can sometimes have interesting side effects. Many queries because
of the where clause conditions will still return the right result set,
but do so slightly less efficiently than the query could if it was
coded correctly. And then sometime you end up with a few extra rows
that do not get noticed in testing but eventually cause a problem that
has to be tracked down.
HTH -- Mark D Powell -- Received on Fri Mar 03 2006 - 08:41:45 CST