Execution plan mystery

HI Experts,

i have a perfect index on the table but when i query it its uses the index but SORT ADDITIONALLY ,but i have already sorted index why its happning, however by expressing the query in another why i am able to achive that , but not sure why expressing the query in simple term QO not using the index well and adding a sort operator. THANKS

avatar image By NEERAJ PRASAD SHARMA 50 asked Feb 04, 2016 at 08:55 AM
more ▼
(comments are locked)
10|10000 characters needed characters left

1 answer: sort oldest

answer deleted - I opened the wrong query plan (from another question)

avatar image By Thomas Franz 16 answered Feb 11, 2016 at 04:53 PM
more ▼
(comments are locked)
10|10000 characters needed characters left
Your answer
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.