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
Printable View
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
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.
select rowid from table_name where_clause
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