CHAPTER 7Basic Hint Syntax (Developer and DBA)
While the optimizer is incredibly accurate in choosing the correct optimization path and use of indexes for thousands of queries on your system, it is not perfect. Oracle provides hints that you can specify for a given query so that the optimizer is overridden, hopefully achieving better performance for a given query. This chapter focuses on the basic syntax and use of hints. The chapters following this one (Chapters 8 and 9) have more complex examples, using various hints covered in this chapter.
The most useful hints that you use for your system may not be the same ones that I have found to be best, because of the diversity of every system. Common to most systems is the use of the FULL, INDEX, ...
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.
