What is sys.dm_db_index_physical_stats DMV?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is sys.dm_db_index_physical_stats DMV?
Rating:
The sys.dm_db_index_physical_stats DMV is used to get information about fragmentation of data and indexes of a table or view. When there is a change or insertion of data in a table or view through the INSERT, UPDATE, or DELETE statement, it causes fragmentation, which in turn causes additional page reads.
Rating:
Was this information helpful?
Other articles
- What is the secedit command?
- What is SSAS?
- What is the Physical Disk: % Disk Time counter?
- What is the dtexec utility?
- What is SQL Server Browser Service?