Post reply

Change in execution plan in change in constraint

  • November 25, 2013 at 5:42 am

    #282841

    I am running following query

    SELECT field1, field2, field3, field4, field5

    FROM vwSomeView WHERE Field1 LIKE 'ABC006%' ---- Taking 41 sec This is using Index scan

    SELECT field1, field2, field3, field4, field5

    FROM vwSomeView WHERE Field1 LIKE 'ABC%' ---- Taking 5 sec This is using index seek

    I have also tried to find missing indexs but sql doesn't show any missing index. Please let me know is i am missing some thing.

    Thanks in advance.

  • November 25, 2013 at 8:56 am

    #1668844

    Have you updated the statistics on the table lately?

    MCITP SQL 2005, MCSA SQL 2012

  • November 25, 2013 at 12:09 pm

    #1668933

    have you checked with profiler...

  • November 26, 2013 at 2:17 am

    #1669055

    Thanks @RTaylor2208. Updated the statistics and it worked fine.

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

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