I totally agree with Gogula's comments.

If you use more than one column in your WHERE clauses,  you may be able to remove some of columns from indexes as other columns can be used for searching..

 Additionally,  one of the reason of long time needed for creatiion of Clustered Index.  This moves the data into different pages, I suggest that you should create the clustered index before loading the data.

You have an index on WorkAdd1, Workadd2... I think you should remove the some two columns unless you see a real benifit. - Actually you can add the indexes later if you need

I suggest that you should remove especially the larger columns from having indexes.

 

 

---

G.R.Preethiviraj Kulasingham MCITP: DBA
http://preethiviraj.blogspot.com/
Plan Your Work and Work Your Plan!