Creating an Index Using the Index Properties Dialog Box

To create an index using the Index Properties dialog box

  1. In the Table Editor, open the table where you want to define an index. The table appears in the Table Editor window.
  2. Click the Indexes tab.
  3. In the Indexes page, right-click and select New Index from the popup menu. The Index Properties dialog box appears.
  4. In the General page, enter the name of the index.
  5. Select Duplicate or Unique from the Index Type list box.
  6. If the index type is Duplicate, select Enabled or Disabled mode.
    If the index type is Unique, select Disabled, Filtering with Errors, or Filtering without Errors modes.
  7. Enter fill factor in the Fill Factor spin box.
    The fill factor allows for expansion of the index or for the creation of compacted indexes. You can only set an index fill factor when the index is first created. For a new index, the default fill factor of 90 percent.
  8. Check the check box to cluster the index.
    There can be only one clustered index per table.
  9. Click the Keys tab of the Index Properties dialog box. 
  10. Click the Key column and select a table column from the list box to specify the index key.
    The Keys column contains all columns for the current table. There must be at least one key for each index.
  11. Click the Sort column to select the sort order.
  12. Click the Location tab.
    Select a storage location for the index from the Index Location list box.
  13. Click OK for the new index and its keys appear in the Indexes page of the Table Editor window.
  14. Choose Table->Execute to save the new index to the database.

  Tips