Home » RDBMS Server » Server Administration » Index on aTable
Index on aTable [message #256723] Mon, 06 August 2007 08:03 Go to next message
swapnajojo
Messages: 40
Registered: June 2007
Location: India
Member
How many indexes can be created for a table?Does more indexes on a table effect performance?

Thanks in Advance
Re: Index on aTable [message #256740 is a reply to message #256723] Mon, 06 August 2007 08:35 Go to previous messageGo to next message
Noemi
Messages: 12
Registered: August 2007
Location: Hungary, Budapest
Junior Member

32 indexes can be created, correct me, if not
Re: Index on aTable [message #256745 is a reply to message #256723] Mon, 06 August 2007 08:49 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How many indexes can be created for a table?

There is no limit but all possible column combinations.
(Database Reference, Annex A Database Limits, Section Logical Database Limits).

Quote:
Does more indexes on a table effect performance?

Of course, each time you modify a value in an indexed column you have to modify the related index.

Regards
Michel
Previous Topic: About Global Name
Next Topic: Oracle product information
Goto Forum:
  


Current Time: Sat Dec 03 18:24:58 CST 2016

Total time taken to generate the page: 0.07448 seconds