Chapter 3 Building Physical Diagrams

Rebuilding indexes from a model or from a package

Steps To rebuild indexes from a model:

  1. Select Tools→Rebuild Objects→Rebuild Indexes.

    The Rebuild Indexes dialog box appears.
  2. Select rebuild options.
  3. Click the Selection tab to display the selection page.
  4. Select the model, for which you want to rebuild indexes, from the dropdown list at the top of the page.

    The tables in the selected model are displayed.

    Note   Rebuilding indexes in a package
    To rebuild indexes in a package, select the package from the dropdown listbox at the top of the page.To rebuild indexes in a sub-package, select the Include Sub-Packages icon next to the dropdown listbox, and then select a sub-package from the dropdown list.

  5. Select check boxes for tables containing indexes to rebuild.

    Clear check boxes for tables containing indexes that you do not want to rebuild.
  6. Click OK.

    A message box asks you to confirm the deletion and rebuilding of key indexes.
  7. Click the Yes button.

    You return to the current model. All key indexes have been rebuilt.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.