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 given the facility to query the data while it is being loaded; loading is a continuous process with a bulk-insert batch size of 100,000. Hence i create the indexes when the table is created.