Descending indexes extend the functionality of a B*Tree index. They allow for a column to be stored sorted in descending…
Hopefully, after reading this chapter you have come to the conclusion that not all tables are created equal. Oracle provides…
Oracle provides an internal PL/SQL package DBMS_BLOCKCHAIN_TABLE that can be used to perform the following: •\ Delete rows in a…
Setting PCTFREE is sometimes overlooked. On the one hand, you need to use it to avoid too many rows from…
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…
I do not use nested tables as a permanent storage mechanism myself, for the following reasons: •\ The unnecessary storage…
In general, the PCTFREE parameter tells Oracle how much space should be reserved on a block for future updates. By…
As shown in the previous section, when you generate statistics for a temporary table, the statistics are visible only to…
That aside, what is important to know about heap tables? Well, the CREATE TABLE syntax spans some 100+ pages in…