Basic Index Principles (Beginner Developer and Beginner DBA)
This chapter is neither for the experts nor for those looking for fast answers. This is a chapter (maybe the only one) that looks at very basic indexing theory, including some new features in version 12c Release 2 (12cR2), such as multiple types of indexes on the same column(s). The toughest part of being a beginner is finding information that will fill in the most basic gaps and enable visualization of Oracle’s indexing capabilities. This chapter is intended to serve that purpose. While a considerable amount of material is published at the intermediate and advanced level, ...