Wednesday, March 28, 2012

long running query

Hi Every one,
In the next query, it's longer when a spell the fields i
want to be returned than if i just write select * .
This :
SELECT Product.Prd_Dc1 , Product.Prd_Dc1A,LotWO_Printed ,
DetCmd.Cmd_No , ProDep.Pro_Des,ProDep.Pro_DesA,
from .... many tables with inner join
is longer than this :
select * from ...the same table
There must be something not up to date in the database
but what is it ? Stats ? Index ?
thanks !
donaldWell, it may just be miscommunication, but your two examples are not the
same thing. One includes at least a reference to "many...joins" and the
other is just a SELECT. Are the two statements truly the same except for
the *?
"Donald" <anonymous@.discussions.microsoft.com> wrote in message
news:ca4d01c43908$a28037d0$a101280a@.phx.gbl...
> Hi Every one,
> In the next query, it's longer when a spell the fields i
> want to be returned than if i just write select * .
> This :
> SELECT Product.Prd_Dc1 , Product.Prd_Dc1A,LotWO_Printed ,
> DetCmd.Cmd_No , ProDep.Pro_Des,ProDep.Pro_DesA,
> from .... many tables with inner join
> is longer than this :
> select * from ...the same table
>
> There must be something not up to date in the database
> but what is it ? Stats ? Index ?
> thanks !
> donald|||Sorry, yes, they are truly the same expect for the
Select part.
One is : Select *
and the other is : select field1, field2, etc...
I do not understand. some cue please.
Thanks !
Donald

>--Original Message--
>Well, it may just be miscommunication, but your two
examples are not the
>same thing. One includes at least a reference
to "many...joins" and the
>other is just a SELECT. Are the two statements truly the
same except for
>the *?
>"Donald" <anonymous@.discussions.microsoft.com> wrote in
message
>news:ca4d01c43908$a28037d0$a101280a@.phx.gbl...
Product.Prd_Dc1A,LotWO_Printed ,[vbcol=seagreen]
>
>.
>

No comments:

Post a Comment