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, 1365🔥, 0💬
Popular Posts:
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...