Descending indexes extend the functionality of a B*Tree index. They allow for a column to be stored sorted in descending…
One of the interesting things you can do with a B*Tree index is compress it. This is not compression in…
The blockchain row retention clause controls when rows can be removed from the table.The syntax for the blockchain row retention…
Object tables are used to implement an object-relational model in Oracle. A single object table will create many physical database…
Oracle provides two types of temporary tables: global and private. Either type of temporary table can be useful in an…
Setting PCTFREE is sometimes overlooked. On the one hand, you need to use it to avoid too many rows from…
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…
The gathering and use of global temporary table statistics is listed next: •\ By default, session-level statistics are generated when…
Nested tables are part of the object-relational extensions to Oracle. A nested table, one of the two collection types in…