Post reply

Execution plan showing Table scan though Index is present

  • September 21, 2010 at 1:24 am

    #1224582

    lallu_jaya (9/21/2010)

    My question is where did this date come from?

    post the query

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • September 22, 2010 at 2:34 am

    #1225379

    hi,

    if its not a highly transactional table try creating a clustered index on timestamp. unique index on the key coloumn.

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

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