Post reply

execution plan

  • May 24, 2008 at 9:05 am

    #819998

    Please provide DDL and sample data.

    For details, please read http://www.aspfaq.com/etiquette.asp?id=5006

    SQL = Scarcely Qualifies as a Language

  • May 24, 2008 at 9:32 am

    #820001

    this both table has 1020 columns ...

    there is no relation ship .. constraint .. only this 2 column is having non cluster index .. nothing else ..

    and 4.5 lak data having ..

    if i include the index column in select i can see index scan .. but this is not possible .. in another place i have choosen 350 columns ...

  • May 24, 2008 at 2:03 pm

    #820010

    Table and index definitions please.

    How many rows do the two tables have? How many does this query return?

    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 3 posts - 1 through 4 (of 4 total)

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