Results 1 to 3 of 3
Thread: query conditions workings
Jan 17, 2010, 20:58 #1
- Join Date
- Sep 2008
- 0 Post(s)
- 0 Thread(s)
query conditions workings
I think the answer may be yes but I need to be sure...
If I query my table, and I have a WHERE and 2 AND clauses; do they each reduce the data set that the next clause has to deal with such that the query becomes leaner as it is processed or; do they all get applied at the same time, at the end of the query?
say I query this
Will the WHERE & 1st AND reduce the data that the 2nd AND must manipulate?