Lets take one stored procedure having 3 delete statements took 10 mins to complete execution.Customer asking to reduce the execution time.
Table size:2.5GB
As a DBA,What will we do?
1.First check for presence of index in the condidtional columns in the delete statements.
2.If no means,please create non-clustered index in the conditional coulmns in the tables available in the delete queries.
3.Then execute the stored procedure.
4.Now it will took 50seconds to finish execution.
5.Thats it.
Let us know for anyother ways?
Table size:2.5GB
As a DBA,What will we do?
1.First check for presence of index in the condidtional columns in the delete statements.
2.If no means,please create non-clustered index in the conditional coulmns in the tables available in the delete queries.
3.Then execute the stored procedure.
4.Now it will took 50seconds to finish execution.
5.Thats it.
Let us know for anyother ways?
No comments:
Post a Comment