Execution plan mystery

NEERAJ PRASAD SHARMA 2016-02-04 08:55:10

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

Thomas Franz 2016-02-11 16:53:32
answer deleted – I opened the wrong query plan (from another question)