On Feb 12, 2006, at 22:46, Adam wrote:

> Helen, I can think of one use for a select first 1 without an order
> by.

I have just done something similar to check for NULLs without
indexing (I may not have control over the database being queried):

select first 1 <field> from <table> where <field> is NULL;

Hopefully, this will just read records in the most convenient order
until it hits one and then stop. Anyone know if this is any faster
than a full table scan?
________________________________________________________
Richard Wesley Software Engineer
Tableau Software
(w) +1-206-633-3400x505
hawkfish@...
http://www.tableausoftware.com/



----------


Visual Thinking for Business Intelligence



[Non-text portions of this message have been removed]