In addition to the denormalization of previously applied normaliza-
tion, some relational databases allow for specialized objects. Oracle Data-
base allows the creation of specialized database objects largely for the
purpose of speeding up query processing. One of the most effective meth-
ods of increasing query performance is by way of reducing the number of
joins in queries. Oracle Database allows the creation of various specialized
objects just for doing this type of thing. Vaguely, these specialized objects
are as follows:
Bitmaps and IOTs
. Special index types, such as bitmaps and index
organized tables. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.