basic index principal

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 cause performance to come to a grinding halt or cause processes to be terminated because of deadlock situations.

Making the correct choice can make you an instant hero, by taking processes that previously took hours or even days to run and providing the resources to finish these processes in minutes.

This chapter will discuss each of the indexing options and point out the benefits and limitations of each.

Tips covered in this chapter include the following: