Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The next step is to find the indexes that are currently applied to the table.  This This is necessary because they will be rebuilt after they have been totally removed.  The The Index Summary window, in the Database Manager, displays the number of BTree, Cross Reference, and Relational indexes for each table.  This This window display is illustrated below:

...

According to the summary window, the CUSTOMERS table has 3 BTree indexes and 1 Cross Reference index, for a total of 4 indexes.  While While accurate, this is somewhat misleading.

...

So, the current indexes are:  2 2 BTree indexes (FNAME and LNAME), and 1 cross reference index (CUSTOMER_NAME).

...