Posted by marianowic on 05/17/07 10:50

Hello everyone.
I have got a simple question, but very important for me.
I making a quite big report and I have a lot of conditions to compare.
And I wonder, what is faster:
One SELECT statement with three comparing conditions
OR
Three SELECTS, each with one comparing condition
All the conditions are separated by AND condition.

The Store Procedure is being made on MS SQL SERVER 2000, the size of
table is around 22098165 records.

Thanks a lot for help... marianowic

[Back to original message]