Optimalization - SELECT tatement
am 17.05.2007 12:50:01 von marianowic
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
Re: Optimalization - SELECT tatement
am 17.05.2007 14:50:51 von Dan Guzman
Please don't post the same question independently to different groups. This
has been answered in microsoft,public.sqlserver.programming and
microsoft,public.sqlserver.server.
If you have a question appropriate for multiple groups, post the question
once and specify all relevant groups (crosspost). This will allow all
parties to follow the complete thread and avoid duplication of effort.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"marianowic" wrote in message
news:1179399001.473679.200900@w5g2000hsg.googlegroups.com...
> 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
>