RE: Record seach options - millions of records

["Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>]

> Note that if you are using EXISTS, the fields in the select clause
don't matter.

True. However, DB2/400 doesn't allow a select w/out the from clause, so
you can't just check for exists(), you need to select from somewhere
where exists()... So now you've introduced another table.

Ideally you should be able to do:

Select 1 where exists(select * from xxx where ...)

There are many times you're just checking for existence. However, we
need to do a:

Select 1 from sysdummy where exists(selct * from xxx where...) 

And now that's just getting ugly. 

-Walden