title: Does bitmap index full scan perform sort in Oracle?
body: <p>One of the differences between index fast full scan and index full scan should be that index fast full scan reads the leaves as how it is stored in the disc. So it needs to perform a sort operation if there is an order by clause. But the index full scan reads the leaves in sorted order. So there shouldn't be a sort after reading it, even if there is an order by with the indexed column. But on the execution below, it performs a sort operation after reading with index full scan. Could you please tell me the reason?</p>
  <p><a href="https://i.stack.imgur.com/8jQ3N.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8jQ3N.jpg" alt="enter image description here" /></a></p>