Chapter 15 DBMS-Specific Features

Creating a join index in the list of join indexes

If you need to create more join indexes than those automatically created by the rebuild process, you can use the list of join indexes.

Note   Several references can be made at once
The following procedure shows how to create a join index in its simplest form: using one reference at a time. Once you become familiar with join index creation, you can select several references at once to reflect a more complex query plan.

Steps To create a join index in the list of join indexes:

  1. Select Model→Join Indexes.

    The List of Join Indexes is displayed.
  2. Click a blank line in the list.

    or

    Click the Add a Row tool.

    An arrow is displayed at the beginning of the line.
  3. Type a join index name in the Name column.

    This is the name of the join index. The code automatically equals the join index name.
  4. Click the Properties tool.

    A confirmation box is displayed asking you to commit the creation of the database object.
  5. Click Yes.

    The join index property sheet opens to the General tab.
  6. Click the References tab.

    The References tab is displayed. It contains the references of the join index. The list is empty when you create a new join index.
  7. Click the Add References tool.

    A selection dialog box is displayed. It displays all the references in the PDM.
  8. Select a reference in the list.
  9. Click OK.

    The selected reference is displayed in the References list.
  10. Click OK in each of the dialog boxes.

    The join index is created.

 

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