viewing info about indexes

[ser]

hi

since indexes are logical structures which keep pointers to tables records. i.e it keeps the rowid for that record which is to be indexed. how would i view this rowid for that record .

thanks

[SANJAY_G]

What do you mean by logical structure? Index is physical structure and keeps the index data saperately.
ROWID for a row you can get from the base table.

[abhaysk]

select rowid from table_name where_clause

[ser]

thanks for your help

i had another query. while calculating pctfree for b-tree indexes the formula given is percentage of total space minus the block header. where would i get the block header info from.

in the manuals they also have mentioned that pctfree parameter for an index works differently from that of a table. what is the differene

thanks