Post reply

Is indexes are helpful on this query?

  • August 4, 2011 at 3:29 pm

    #1364016

    Nope. You're asking for every column, every row. That's a table scan, there's no faster way to fetch the entire table.

    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 4, 2011 at 3:31 pm

    #1364018

    That is what I expected too..but I was asked to tune this query .ha.haa.What to do ?

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

  • August 4, 2011 at 3:34 pm

    #1364020

    Nothing.

    Putting an appropriate clustered index in place instead of a heap might save a second or 2, maybe.

    Or you could request hardware upgrades. A faster network, more memory and better IO subsystem might help.

    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 4, 2011 at 3:38 pm

    #1364021

    Thanks

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

Viewing 4 posts - 1 through 5 (of 5 total)

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