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.
