Basic Hint Syntax (Developer and DBA)
Although the cost-based 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. To this end, Oracle provides hints that you can specify for a given query to override the optimizer, 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 ...