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