Quote:
Originally posted by bensmail
I h've following problem:
I run a insert ....select.... in my DB and it take forever.
the execution of the select statement is immediate, but the insert 2 hours.
This insert statement is run every day and it took 13 minutes for 3 days while a month.
I don't make changes in my database or my server and the number of line is the same.
Bensmail
Insert WAS working fine, but not now.. hummm.. Check for indexes.. try rebuilding them. And check for storage clauses of the table that is getting inserted. check for number of extents.