How Many Indexes Can Be Created Per Oracle Table?
Unlimited Indexes can be created per Oracle Table.
But Total number of columns per table that can be indexed is 32 for B-Tree index and 30 for Bit Map index.
You can create many indexes for a table as long as the combination of columns differs for each index. You can create more than one index using the same columns if you specify distinctly different combinations of the columns.
For example, the following statements specify valid combinations:
CREATE INDEX emp_idx1 ON emp (first_name, job_id); CREATE INDEX emp_idx2 ON emp (job_id, first_name)
NB: Maximum number of columns possible in an Oracle Table is 1000.