Db2 Coding - General SQL and Indexing Guidelines - Expert Videos
Duration
45 minutes
Overview
These expert videos focus on the benefits of using indexes when accessing data through SQL. It begins by looking at using SQL to obtain only the data required, and minimizing the passes through that data. You will see how indexes can improve SQL performance and also where indexes cannot be used. Finally, you will see how the way that Db2 data is stored can also impact performance when accessing it.
Audience
This is aimed at individuals whose job role is to analyze and improve the performance of their Db2 database programs.
Prerequisites
Successful completion of the Interskill, Db2 Coding - Coding Relationally - Expert Videos, or equivalent knowledge.
Objectives
After completing this course, the student should be able to:
- Identify SQL Code that Would Benefit from Using Indexes
- Explain how Indexes Work
- Describe How the Storage of Db2 Data Can Impact Performance
Course Content
Types of SQL
SQL Operations
Types of SQL and Who Uses Them
SQL SELECT Clause Structure
SQL Coding Best Practices
Optimizing Your SQL Code
Retrieving Only Required Data
Matching Data Type and Length
Minimizing Passes Through the Data
Avoiding Running SQL Through a Black Box
Indexes and Performance
What is an Index?
Index Processing
Multicolumn Indexes
Identifying Existing Indexes
IBM Db2 Admin Tool
Accessing Data Using the Primary Key
Index Only Access
Multiple Index Access
Where Indexes Cannot be Used
Stages and Clustering
Stage 1 and Stage 2 Predicates
Data Clustering Processing
Benefits of Data Clustering
Sequential and Random Data Access