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... marianowicPlease 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.comwrote in message
news:1179399001.473679.200900@.w5g2000hsg.googlegro ups.com...
Quote:
Originally Posted by
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
>
I didnt think it will make so big problem.
I will not do it again|||Thanks for your consideration.
--
Dan Guzman
SQL Server MVP
"marianowic" <marianowic@.gmail.comwrote in message
news:1179485229.418766.101720@.p77g2000hsh.googlegr oups.com...
Quote:
Originally Posted by
Sorry!
I didnt think it will make so big problem.
I will not do it again
>
>
>
No comments:
Post a Comment