Collections:
Defragmenting Table Indexes in SQL Server
How To Defragment Table Indexes in SQL Server?
✍: FYIcenter.com
When a table index is fragmented to a certain percentage, you need to defragment the index to maintain its performance level. There are 3 ways to defragment:
1. "ALTER INDEX index_name ON table_name REORGANIZE" - Defragmenting the specified index performed in online mode. No locks applied on affected table. Used for indexes with a small fragmentation percentage.
2. "ALTER INDEX index_name ON table_name REBUILD" - Defragmenting the specified index performed in offline mode by default. It can be performed in online mode. Used for indexes with a large fragmentation percentage.
3. "CREATE INDEX ... WITH (DROP_EXISTING = ON)" - Re-creating the specified index. The definition of the index can be changed.
⇒ "ALTER INDEX ... REORGANIZE" - Defragmenting Indexes in SQL Server
⇐ What Causes Index Fragmentation in SQL Server
2016-11-08, 1843🔥, 0💬
Popular Posts:
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...