Rebuilding the Indexes
Rebuilding the Indexes
Do not rebuild indexes while users are accessing the data for this table. Doing so may result in inaccurate query results.
The procedure to rebuild the indexes for a table is:
-
If the table has any views defined that have the WITH CHECK OPTION clause, remove these views with the DROP VIEW command. (You can re-create these views after updating who has access to each row).
-
From the Management Portal home page, go to the SQL page (System Explorer > SQL) page.
-
Select the namespace that contains the table.
-
Under Tables, select the name of the table. This displays the Catalog Details for the table.
-
On the Actions drop-down list, click Rebuild Table’s Indices.
For more information on rebuilding indexes, see Define and Build Indexes.