Index on aTable [message #256723] |
Mon, 06 August 2007 08:03 |
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 #256745 is a reply to message #256723] |
Mon, 06 August 2007 08:49 |
|
Michel Cadot
Messages: 68686 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
|
|
|