Database Reference
In-Depth Information
Figure 8.22
Workload distribution before indexing.
Figure 8.23
Cost before indexing.
8. Highlight the code and click the
Run
tab. As shown in Figure 8.24, the index Class_
Index is successfully created.
9. After the index is created, highlight the following SQL Statement and click the
Actual
Plan
tab again:
SELECT ClassID, CourseName
FROM COURSE, CLASS
GROUP BY CourseName, ClassID
10. As shown in Figure 8.25, the workload on sorting is no longer a major factor of the
execution.
