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, ...

Get Oracle Database 12c Release 2 Performance Tuning Tips & Techniques now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.