Images

CHAPTER

2

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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.