O'Reilly logo

Oracle Database 12c Release 2 Performance Tuning Tips & Techniques by Richard Niemiec

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Images

CHAPTER

7

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 (even with 12c Adaptive Query Optimization). 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 in this chapter.

Because every system is diverse, the most ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required