Reorganize restructures the information on the pages instead of dropping and then re-creating the indexes. Depending on the type of index and the database engine version, a rebuild operation can be done offline or online. Note: Rebuilding an index drops and then re-creates the index. Index fragmentation occurs as gaps in data pages and logical fragmentation. It's a best practice to monitor the level of fragmentation and rebuild and reorganize indexes regularly. Index fragmentation is a critical issue that can cause performance problems in SQL Server databases if they aren't rebuilt promptly.
0 Comments
Leave a Reply. |