Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raniait
Starting Member
14 Posts |
 Posted - 2002-11-26 : 14:34:20
|
| Hi What is the optimized solution of the indeces on table which i read ,insert,update and delete from it?As Indeces can accerelate the selection but it will slow down the update,deletion and insertion.Thanks |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-11-26 : 15:24:17
|
| It depends :)Do the inserts/updates happen in one big bulk each day, or it it a lot of 1 record inserts/updates all the time? If you have the bulk inserts, generally it's best to drop the indexes, import/update the data, then re-add the indexes.I think the general rule on this is to do some testing and see what is best in your particular case. If you want more detailed help, tell us more about the insert, updates, and deletes.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
raniait
Starting Member
14 Posts |
Posted - 2002-11-27 : 01:28:16
|
| yes It is a lot of 1 record inserts/updates all the time done weakly it is somthing like weakly articles archieving Thanks a lot for ur advice |
|
|
|
|
|
|
Indeces Optimization