View the Exhibit and examine the command used to create the ZONEDATA table. The table
contains a million rows for zonewise analysis in the DSS system. DML operations are performed
very rarely on the table. You decide to prepare an index on the ZONE column to enhance the
performance of the queries on the ZONE column.
Which type of index would you select in this scenario?
A.
Bitmap index
B.
Reverse key index
C.
Normal BTree index
D.
Functionbased index