|
|
Posted by Dan Guzman on 05/17/07 12:50
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" <marianowic@gmail.com> 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
>
Navigation:
[Reply to this message]
|