I have a partitioned table that has indexes. I want to finf out if the indexes are normal or global. I checked the index_type column of dba_indexes and it say normal.
Does that mean the indexes are global or local?
Printable View
I have a partitioned table that has indexes. I want to finf out if the indexes are normal or global. I checked the index_type column of dba_indexes and it say normal.
Does that mean the indexes are global or local?
It only means it is B*tree index type. For information on partitioning, search the column PARTITIONED in DBA_/ALL_/USER_INDEXES or check the DBA_PART_INDEXES view.
I checked and I could not find the column that contains that information. Can you please tell me the column name under
dba_part_indexes where I can find if the indexes are global or local?
Thanks
Check the column DBA_PART_INDEXES.LOCALITY
hth,
Hi, 22nd April 2001 17:04 hrs chennai
Use
ALL_PART_INDEXES====>
LOCALITY column which tells Indicates whether this partitioned index is LOCAL or GLOBAL
ALIGNMENT Columns Indicates whether this partitioned index is PREFIXED or NON-PREFIXED
Cheers
Padmam