Answers to Chapter 13
Reviewing It |
1: | What would be the advantage of a partitioned index? |
A1: | To make less b*tree levels when indexing very large tables |
2: | What is the advantage of an IOT over that of a HEAP Table? |
A2: | No underlying table structure is required |
3: | Why does IOTs have the pseudo column 'ROWID'? |
A3: | So that indexes can be created on IOTs |
4: | What is a b*tree level telling you? |
A4: | The number of levels in the index, the fewest number of reads required to find a table ROWID |
5: | Show the syntax to make a SQL statement use an existing index when a calculation on the indexed column is desired. |
A5: | WHERE sal > 1000/1.10 |
6: | List some of the benefits ... |
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.