This is exactly the reason I adopted the practice some time ago. I used to take them out when pasting the query into a package, etc. But, not so much anymore. With sufficient proof of performance degredation, I would take them out at once. Thanks, Jon Knight -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Wendelken Sent: Wednesday, March 09, 2005 10:07 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Re[2]: Hotsos Symposium, Day 1 >I guess what I'm looking for is --- is there a good, positive >reason to use an expression like 1=1? > I have a colleague who uses WHERE 1 = 1 all the time. I asked him why some years ago. It was because as he tuned or modified statements, he got tired of re-arranging the WHERE and AND clauses all the time. By starting off with WHERE 1 = 1, all the clauses that he would be re-arranging started with AND, so it saves him some bother. Best reason I've heard so far. -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l