Database - RAC/Scalability (MOSC)

MOSC Banner

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center