Execution plan mystery
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
2016-02-11 16:53:32
answer deleted – I opened the wrong query plan (from another question)