Home » SQL & PL/SQL » SQL & PL/SQL » Max Index on a table
Max Index on a table [message #7186] Tue, 27 May 2003 06:30 Go to next message
Ajith
Messages: 13
Registered: May 2003
Junior Member
What is the max number of indexes that can be given on a table?
Re: Max Index on a table [message #7189 is a reply to message #7186] Tue, 27 May 2003 06:57 Go to previous messageGo to next message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
quote from Ajith:
----------------------------------------------------------------------
What is the max number of indexes that can be given on a table?

----------------------------------------------------------------------
According to the documentation:

- Item - - Type - - Limit -

- Indexes - - Maximum per table - - Unlimited -

-   - - total size of indexed column - - 75% of the database block size minus some overhead -

HTH,

A
Re: Max Index on a table [message #7190 is a reply to message #7186] Tue, 27 May 2003 06:59 Go to previous message
venkatesh
Messages: 72
Registered: August 2000
Member
A table can have any number of indexes.

But you need to analyze the requirement. If it is OLTP then u need to have minimum possible number of indexes. But in Datawarehouseing you can have decent number of indexes.
So the table having heavy insert, update, delete is not a right table to have many no. of indexes.

Venkatesh
Previous Topic: Whether Windows XP Prof. accepts Oracle 9i Enterprise
Next Topic: Long boot time since installing Oracle
Goto Forum:
  


Current Time: Thu Mar 28 13:38:35 CDT 2024