Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle scans table with "WHERE (1=0)"?

Re: Oracle scans table with "WHERE (1=0)"?

From: Anurag Varma <avoracle_at_gmail.com>
Date: 7 Apr 2006 20:27:25 -0700
Message-ID: <1144466844.959333.283140@t31g2000cwb.googlegroups.com>

hmm .. I don't know if the "for update" clause should have any different effect, but you might want to read this:

http://www.jlcomp.demon.co.uk/testing_02.html

Anurag Received on Fri Apr 07 2006 - 22:27:25 CDT

This message: [ Message body ]
Next message: Joe Weinstein: "Re: Oracle scans table with "WHERE (1=0)"?"
Previous message: Pratap: "Re: Join cardinality"
In reply to: Joe Weinstein: "Re: Oracle scans table with "WHERE (1=0)"?"
Next in thread: Jonathan Lewis: "Re: Oracle scans table with "WHERE (1=0)"?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US