13.8. Review Questions
Which data dictionary view provides the recommended action, as a SQL statement, from the Segment Advisor?
Which of the following statements is not true about sorted hash clusters?
The new access path is used regardless of the type of predicate in the WHERE clause.
You are allowed to create indexes on sorted hash clusters.
The cost-based optimizer must be used to take advantage of the new access path.
Additional sorts are not necessary if you access the cluster by one of the lists of hash key columns.
More than one table can be stored in a sorted hash cluster.
Consider the following scenario. The user SCOTT runs a query at 8:25 A.M. that receives ...