Hash or Global index on a big table
Oracle 19.26 - 4 node RAC
Some information about the table:
I have a large partition table.
Range partition table = 512 partition
Partition size = 10k to 15k rows (each partition)
Type of index exist now: Normal, Bitmap(unique and nonunique) - Total 19 indexes.
one of the index is unique index and it is a global partition by hash
Questions:
is there a way to run a query and figure out all hash indexes and Global indexes on a range partition table?
Can we have more than one hash index on a range partition table? (we already have a primary key index)
is it possible to have multiple global indexes on a range partition table?