Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

CHAPTER 7: SQL Tuning Techniques > Altering the Access Structures

Altering the Access Structures

This technique is not tied to a specific feature. It is simply a fact that the response time of a SQL statement is strongly dependent not only on how the processed data is stored but also on how the processed data can be accessed.

How It Works

The first thing you have to do while questioning the performance of a SQL statement is to verify which access structures are in place. Based on the information you find in the data dictionary, you should answer the following questions:

  • What is the organization type of the tables involved? Is it heap, index-organized, or external? Or is the table stored in a cluster?
  • Are materialized views containing the needed data available?
  • What indexes exist on the tables, clusters, and materialized views? Which columns do the indexes contain and in what order?

  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint