Rebuilding the Indexes
Rebuilding the Indexes
Caution:
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.