| 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: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
