Originally posted by JMac
Can someone please verify the 'best' order for tables in the FROM clause?

Is it tables that would return LEAST number of rows (given the inidividual query) that should be last.
Or is it smallest tables (whatever the query) that should be last?

Also - In the WHERE clause should the most restrictive statement be last?
Order of table may not matter ... not sure

Order of columns in where clause wud matter some times...

it wud be best if most restrictive column is preceded before any columns...(though it wud go for toss if not indexed col)

The order in which columns are indexes...if used in where clause in same order wud have beter performance ( i blv )..

if i am wrong please bark at me...

Abhay.