CHAPTER 2Basic Index Principles (Beginner Developer and Beginner DBA)

This chapter is neither for the experts nor for those seeking fast answers. This is a chapter (maybe the only one) that looks at basic indexing theory. 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. Although a considerable amount of material is published at the intermediate and advanced levels, information for beginners is usually scarce, yet highly desirable.

Oracle offers a variety of indexing options. Knowing which option to use in a given situation can be crucial to an application's performance. A wrong choice may ...

Get Oracle Database 10g 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.