Post reply

Is simple select statement taking TEMP DB space during execution ?

  • August 27, 2013 at 12:03 am

    #282408

    Hi,

    I have one simple question.... because I don't know about this fact.

    I have one invoice table which contain 10 millions records.

    I simply run statement in query analyzer , Like below

    >> Select * from InvoiceDetails

    I would like to know, Is this select statement taking TEMP DB space during execution ?

    Regards,

    Sachin.

    9891573054

  • August 27, 2013 at 2:55 am

    #1645071

    A simple select * with no joins or aggregates won't use TempDB space, there's nothing in that statement that requires temporary workspace.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 27, 2013 at 3:11 am

    #1645080

    Thanks a lot....:-)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply