I have a table where data is deleted, inserted and updated. What kind of
index is appropriate for the column
where data is deleted ?
where data is inserted ?
where data is updated ?

Thanks for any input.

This depends on many things.  If you post some DDL, we can help you out.

Read up on Indexes in the BOL for some tips on which columns are good
candidates for indexes and which ones are not.


Rick Sawtell
MCT, MCSD, MCDBA

Is LAST_INSERT_ID() same as @@IDENTITY
insert error
Notify users when stop SQL server
max(field) but the field value is not always numeric
dbo does not have a login name..
altering a primary key property
drop clustered index - fails on duplicate key
purchasing a SQL server 2000 system table poster
Log Shipping
nested "starting up database" in the logs