Is it possible to have a look at what is there inside an index using SQL*Plus?
If I have a table like this:
Table A
------------------------
rowid | id name
123 | 1 A
124 | 4 G
125 | 2 R
126 | 3 P
where id
is the primary key, I expect the index to be something like this
index on A.id
-------------
id rowid
1 123
2 125
3 126
4 124
Is there some SQL query using which I can actually see the contents of an index?