Post reply

What happenif we run sql statement

  • March 16, 2013 at 12:27 pm

    #394407

    Hi,

    What happened if we run select statement i.e

    Select * from TableName;

    When we execute the above sql statement what is happened Internally?

  • March 16, 2013 at 12:30 pm

    #1597841

    The query optimiser generates an execution plan, which in this case is a trivial plan that just contains the table scan and select operators. The query execution engine executes that execution plan, requesting every single row in the table from the storage engine, then returning that to the client.

    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

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

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