Date: Thu, 28 Mar 2024 16:20:21 +0000 (UTC) Message-ID: <968310206.68113.1711642821020@ip-10-0-1-26.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_68112_1942368450.1711642821019" ------=_Part_68112_1942368450.1711642821019 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The Rebuild Indexes option on the= Tables and Indexes view allows you to select tables to rebuild. Rebuilding= your tables allows you to decrease the amount of fragmentation on a table.= High table fragmentation can lead to overall performance bottlenecks on yo= ur SQL Server instance.
When you click Rebuild Indexes from the SQL Diagnostic = Manager Console, the Select Tab= les window opens and allows you to choose the table indexe= s to rebuild.
If you are rebuilding indexes on a very large table the rebuild process = could take several minutes to complete. While the rebuild is in process, th= e table is locked and users are unable to access it.
Once the indexes are rebuilt, the % Fragmentation (Current) column displays showing you the results.
If you are rebuilding a very large index, the SQL Diagnostic Manager Con= sole checks for the rebuild status for 90 seconds. If the rebuild is not co= mplete after 90 seconds, the % = Fragmentation (Current) column does not display the new va= lue until the next table statistics collection occurs.