Maintain index on SQL Server table My problem is how do I maintain an index on table, weekly we are deleting and inserting bulk amount of data from the table.Because drop and create index taking too long time..
You could set up a job to rebuild or reorganize them weekly/daily.

I recommend checking out http://sqlfool.com/2011/06/index-defrag-script-v4-1/

This index rebuilder is highly customizable.