Thread: query help
View Single Post
  #10 (permalink)  
Old 03-03-10, 17:22
r937 r937 is offline
SQL Consultant
  
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
Quote:
Originally Posted by virap View Post
If so I tried it without sort too, but it keeps scanning 94000+ rows.
well, the omission of the ORDER BY clause would make your query results hardly useful at all, right?
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote