Re: Multiple parameter for WHERE clause

["Jamadagni, Rajendra" <rajendra.jamadagni@ESPN.COM>]

Sheri ...

Although we used the approach 1=1 awhile back, and in some cases (especially
when using CBO in Oracle), it is possible that the optimizer will resolve to
perform a Full Table Scan because of "1=1" condition.

I cannot guarantee that it will *always* happen, but there is a good chance
it might happen when the moon is in the right phase. Why not remove 1-1 from
the where clause, it doesn't serve any purpose anyway.

HTH
Raj
______________________________________________________
Rajendra Jamadagni              MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
QOTD: Any clod can have facts, but having an opinion is an art !
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.



-----Original Message-----
From: Sheri Woo [mailto:Sheri.Woo@CNPL.ENBRIDGE.COM]
Sent: Wednesday, January 10, 2001 9:31 AM
To: SQR-USERS@list.iex.net
Subject: Multiple parameter for WHERE clause


Anne, regarding your question dynamic where clause. I've seen it done two
different ways.

1. Use 1=1.  We do this all the time and it works just fine.

*********************************************************************

This e-mail message is confidential, intended only for the named recipient(s) 
above and may contain information that is privileged, attorney work product or 
exempt from disclosure under applicable law. If you have received this message 
in error, or are not the named recipient(s), please immediately notify ESPN at 
(860) 766-2000 and delete this e-mail message from your computer, Thank you.

*********************************************************************