Descending indexes extend the functionality of a B*Tree index. They allow for a column to be stored sorted in descending…
B*Tree—or what I call conventional—indexes are the most commonly used type of indexing structure in the database. They are similar…
We have already seen a partial example of an object table with nested tables. An object table is a table…
Object tables are used to implement an object-relational model in Oracle. A single object table will create many physical database…
Here is where the “virtually a table for every row” comes into play. In the SELECT predicate shown earlier, it…
We have already seen some of the storage of the nested table structure. In this section, we’ll take an in-depth…
One of the drawbacks of a temporary table in any database is the fact that the optimizer has no real…
I do not use nested tables as a permanent storage mechanism myself, for the following reasons: •\ The unnecessary storage…
Nested tables are part of the object-relational extensions to Oracle. A nested table, one of the two collection types in…
This table introduces a new option, PCTTHRESHOLD, which we’ll look at in a moment. You might have noticed that something…