Posted by DA Morgan on 04/13/06 21:39

Tony Rogerson wrote:
> Might be aluding to this....
>
> SELECT 1 FROM ACTIVITY_ENTRY WHERE (1=0) FOR UPDATE
>
> Which Oracle gives a table / index scan rather than realising it doesn't
> need to do anything.

In different versions dual behaves very differently. A comparison of
SELECT 1 from Oracle (version dependant) and SELECT 1 in SQL Server are
not necessarily comparable.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

[Back to original message]