Thanks for the input.

i have added a secondary file group and set the non clustered indexes on it.

Primary file (-group) is auto-growing.

The application is basically a for data-mining. We have...

thanks alzdba.

it is not viable to drop and recreate the indexes as

1 . bulk insert is an ongoing process

2 . certain select queries are also fired on the data loaded.

on an...