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.