Following along interactively with Query 4

To follow along interactively with Query 4, you must add a column to an existing index. To do this, you must drop and recreate the original index. This snapshot is identified by the number 7 under Query Number in the Explained Statements History window.

For single-partition database environments only. The following SQL statements were used to drop and create the indexes: 

DROP   INDEX I_DEPTNUMB
CREATE INDEX I_DEPTNUMB_NAME ON ORG   (DEPTNUMB, DEPTNAME)
CREATE INDEX I_JOB           ON STAFF (JOB)

For partitioned database environments only. The following SQL statements were used to drop and create the indexes: 

DROP   INDEX I_DEPTNUMB
CREATE INDEX I_DEPTNUMB_NAME ON ORG   (DEPTNUMB, DEPTNAME)
CREATE INDEX I_JOB_SAL       ON STAFF (JOB,SALARY)

You can use the Control Center to drop and re-create indexes.