Descending indexes extend the functionality of a B*Tree index. They allow for a column to be stored sorted in descending…
Oracle provides many different types of indexes for us to use. Briefly, they are as follows: •\ BTree indexes: These…
When performing direct path operations on a temporary table (where ON COMMIT PRESERVE ROWS is enabled), session-level statistics are gathered…
Oracle provides two types of temporary tables: global and private. Either type of temporary table can be useful in an…
Here is where the “virtually a table for every row” comes into play. In the SELECT predicate shown earlier, it…
One of the drawbacks of a temporary table in any database is the fact that the optimizer has no real…
Nested tables are part of the object-relational extensions to Oracle. A nested table, one of the two collection types in…
Index-organized tables (IOTs) are quite simply tables stored in an index structure. Whereas a table stored in a heap is…
That aside, what is important to know about heap tables? Well, the CREATE TABLE syntax spans some 100+ pages in…
Clustered tables give you the ability to physically prejoin data together. You use clusters to store related data from many…