|
Re: Max Index on a table [message #7189 is a reply to message #7186] |
Tue, 27 May 2003 06:57 |
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 |
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
|
|
|