© Copyright, 2002 Howard F.
Arner, Jr. All Rights Reserved. Unauthorized duplication prohibited.
Create suggested index
•The job log indicates an access
path would help the query
•
•CREATE INDEX
SQLBOOK.WTREQTS
ON SQLBOOK.WEBTEMP2 (REQTS ASC)
•
•Next, we run the
query again and look at the log