CHAPTER 19

image

Advanced Tuning Techniques

When I first planned out this book I imagined that this chapter would be a lot longer than it is. In truth, most of the advanced techniques that I use in SQL tuning have already been addressed in earlier chapters. I just have a couple of educational, if obscure, cases to run through. Let us begin with some unusual ways to use the ROWID pseudocolumn.

The availability of the ROWID pseudocolumn is a distinguishing feature of the Oracle database product. This pseudocolumn can be used to get around quite a few of the characteristics of the product. I use the word characteristics rather than a more disparaging ...

Get Expert Oracle SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.