hello,
Is there any limit on number of index a table can have?
Printable View
hello,
Is there any limit on number of index a table can have?
There is no limit to the number of indexes your table can have.
The only real limit is determined by the number of columns in the table. Oracle will not let you create two indexes that have the same column list.
For example.
if you have table T(col1, col2)
you can have indexes
(col1)
(col2)
(col1,col2)
(col2,col1)
and that is all