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 ...