Reviewing It

1:What would be the advantage of a partitioned index?
2:What is the advantage of an IOT over that of a HEAP Table?
3:Why does IOTs have the pseudo column 'ROWID'?
4:What is a b*tree level telling you?
5:Show the syntax to make a SQL statement use an existing index when a calculation on the indexed column is desired.
6:List some of the benefits and penalties of using bitmapped indexes.

Get Oracle9i™ Development by Example now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.