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.

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)

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.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]