>Should test some insert, delete and update to see if new index slows down those process.
Insert: you can keep it under control by the FILL FACTOR (experiment between 50-80) .
Delete: try to avoid. This really messes up the index tree. Use an IsActive bit flag instead.
Update: may or may not be an issue. If in place or not on index column, fairly fast.