Oracle Database 11gR2 Performance Tuning Cookbook

Chapter 8. Other Optimizations

In this chapter, we will cover:

• Caching results with the client-side result cache
• Enabling parallel SQL
• Direct path inserting
• Using create table as select
• Inspecting indexes and triggers overhead
• Loading data with SQL*Loader and Data Pump

Introduction

In this chapter we will look at optimizations related to both queries and DML operations.

The first two recipes will show some features that can speed up a query; the following four recipes are focused on different techniques useful to load data in the database, from external sources and from other tables inside the database.

We will also focus on the overhead introduced by indexes and triggers. We have seen in past recipes that using indexes can speed up our queries, resulting ...