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
add new comment
(comments are locked)
|
answer deleted - I opened the wrong query plan (from another question)
(comments are locked)
|