You can include indexes selectively in an object profile, or you can use wild cards to add indexes at job build time. You can include indexes by database name, creator name, or index name, with or without wild cards. Custom SQL can also be used to specify other criteria to select indexes.
Procedure
On the Add Objects to the Objects Profile window,
enter Y in the Add Indexes field
and press Enter.
The window that is shown in the following figure is displayed:Figure 1. Enter Indexes Like to Display window
--------------------- Enter Indexes Like to Display ---------------------
Database Like *
Creator Like PDUSR* >
Index Like * >
Wildcard N (Yes/No) Exclude I (E - Exclude, I - Include)
Process Cloned Indexes N (Yes/No)
Advanced SQL . . . . N (Yes/No) Update SQL N (Yes/No)
What to do next
Use the Enter Indexes Like to Display window to
select the indexes that you want to include or exclude. For more information, see the following
topics: