How many indexes [message #51589] |
Sat, 01 June 2002 01:16 |
K. Prakash babu
Messages: 46 Registered: July 2001
|
Member |
|
|
Hi
I have a table of 1 million records. and it is having around 5 child tables also. I created 8 indexes on my parent table as while tuning i found that it is in need of that much indexes. As of now the performance also quite satisfactory. Will this reduce the performance if the no. of records increased???
could anybody give me the answer asap?
Thanx in Advance
|
|
|
Re: How many indexes [message #51597 is a reply to message #51589] |
Sat, 01 June 2002 08:12 |
alapps
Messages: 11 Registered: June 2002
|
Junior Member |
|
|
Adding indexes to a table will:
*** Increase performance on queries
(Don't forget to tune SQL statements)
*** Decrease performance on DML statements
- INSERT, UPDATE, DELETE
|
|
|
Re: How many indexes [message #51609 is a reply to message #51597] |
Sun, 02 June 2002 22:15 |
Nishant
Messages: 20 Registered: August 2001
|
Junior Member |
|
|
Hi,
As your indexes are on master table which would not have frequent inserts , I dont think the performance will go down if records are added to child tables.
Take Care.
|
|
|