Optimize Table

Hi team

I have table which contains million rows and 500 columns and while inserting 30 lakh data in to another table.it is taking time an 1 hour.Please share the optimising process.Clustered index already created on date column.PLease fin my query

insert into select * From table 1 where eventdate>='2015-11-02'

drop all non-clustered indexes before insert, then rebuild them after insert. Also, are all the new dates > all the current dates in the table?


Thanks for the suggestion.But i am using the CTE now.it is taking less time.

that makes no sense at all. A CTE isn't a performance tool; it's just an easy way to define subqueries. Unless you've changed the way the resulting query is done (check the execution plan) the performance (and the plan) would be identical.