I recently stumbled upon a situation where my index was much larger than
my table, does anybody have a query I can use to find ther similiar situations.
This needs to work for all combinations of partitoned and non partioned
tables and indexes
Printable View
I recently stumbled upon a situation where my index was much larger than
my table, does anybody have a query I can use to find ther similiar situations.
This needs to work for all combinations of partitoned and non partioned
tables and indexes
Objects that consume space require segments. Segments have a type and size. So you find all indexes for a table. Compare sum of one index against the sum of the table.