Database Reference
In-Depth Information
Figure 8.24
Create Class_Index.
Figure 8.25
Workload distribution after indexing.
11. To view the cost of the SELECT statement after indexing, double click the SELECT
node. As shown in Figure 8.26, the total cost for the SELECT statement is 0.000731994,
which is over 25 times better.
12. he last step is to drop the index with the following SQL statement:
DROP INDEX class_Index ON COURSE
13. Highlight the SQL Statement and click
Run
. Figure 8.27 shows that the index is
dropped successfully.
