Chapter 10. Performance Tuning
In this chapter, I describe a number of features that you can use to increase the speed of your SQLJ programs. I show you how to retrieve rows from the database in blocks using prefetching and how to combine SQL operations into batches. I introduce you to the subjects of tuning your SQL statements and using the Oracle optimizer. One thing you should bear in mind when reading this chapter is that tuning is as much an art as it is a science. You'll need to experiment a bit with the different techniques described here when tuning your own programs.
Get Java Programming with Oracle SQLJ 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.