Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 483 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

Full site membership is required for this article. Already a full member? Login here.
You currently have a guest membership. You can upgrade to full site membership here (free trial available).

DB2 Access Paths


 Article Abstract:

(Craig Mullins) An access path is an algorithm used by DB2 to satisfy the requirements of SQL statements. Before any SQL statement can be run, it must be broken down, parsed, and turned into executable code. There are many different types of access paths used by DB2 that must be properly understood in order to create optimal SQL.

The DB2 optimizer can choose from a variety of different techniques as it creates optimal access paths for each SQL statement. These techniques range from a simple series of sequential reads to much more complicated strategies such as using multiple indexes to access data. Let’s learn about some of the most popular techniques used by the optimizer to formulate DB2 access paths.

 Read this article...
 Related Articles - For Members.
All Articles By Author

Moving to DB2 9: Considerations and Migration Part 2
Moving to DB2 9: Considerations and Migration
DB2 Performance Traces
An Overview of DB2 for z/OS Version 8
DB2 for z/OS Performance Tuning
DB2 Everyplace: A Mobile DB2
DB2 Field Resources
The DB2 Information Infrastructure
The DB2 Information Infrastructure
Shared Disk and Shared Nothing: Architectures for Clustering



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

No Comments/Feedback Posted Yet. Post Your Comments/Feedback

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   



 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004