The Order Of The Query Result May Not Follow The Order In The Index From 12c
(Doc ID 2542364.1)
Last updated on JUNE 02, 2021
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Oracle Database - Standard Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
A select is querying some columns which are indexed columns. The result should by sorted as they are indexed columns and follow the order in the index.
But the result shows a different order.
For example the query is as follow:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document