Sample Header Ad - 728x90

Do frequent DML operations on a table with indexes and huge data affect SELECT query performance?

1 vote
2 answers
1252 views
If I have frequent DML(insert,update,delete) operations on a table with huge data with clustered and non-clustered indexes. Will it affect the Performance of SELECT queries on that table with a where condition on index columns, Or will the performance remain same as when there are no DML operations? This Link says UpdateStatistics does block Select queries. So will DML operations cause UpdateStatistics. It says " The only time you wouldn’t be in control of this is if AUTO_UPDATE_STATISTICS is enabled on your database and AUTO_UPDATE_STATISTICS_ASYNC was disabled.". So is changing these values the best solution? **Note:**  **I will be using isolation level (Read Uncommitted) for the SELECT query which should not be blocked by locks.**
Asked by Mahen (13 rep)
Dec 14, 2020, 02:24 AM
Last activity: Dec 14, 2020, 02:56 PM