Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Show/Explain Query Plan
I always think that the where clause is the row filtering criteria
Dan Guzman (nospamplease_guzmanda_at_mindspring.com) wrote:
: I believe the table scan plan is correct since there are no joins or row
: filtering criteria. Unfortunately, the plan does not show that the
: evaluation of the literal apparently occurs first so the subordinate table
: scan never takes place when the literal condition is false.
:
: Hope this helps.
:
: Ng K C Paul wrote in message <6tsuh2$neq$1_at_imsp009a.netvigator.com>...
: >Sometimes, I wonder if I should trust the plan returned from the query
: >optimizer. For example,
: >
: >create table aaa (a int)
: >
: >select * from aaa
: >where 1=2
: >
: >Some plans show table scan for the above query. Is it normal?
:
:
Received on Sat Sep 19 1998 - 00:00:00 CDT