If I am interpretting your message correctly, you want to know how many indexes can exist on a table in an Oracle database?
More than you would ever want to or need to create.
Creating too many infrequently used indexes on a table ("Over indexing") slows down performance, especially of INSERTs, UPDATEs and DELETEs. Only create the indexes your application needs.
To determine what indexes would be helpful for your application, either ask someone to review your SQL or use an SQL analysis tool.
Also remember to periodically run ANALYZE commands to update the statistics stored in the Data Dictionary.
-- Michael
Darkstreak Consulting
www.darkstreak.com
