Learning Center Log in Start Learning Free

Query Optimization Basics on Db2 for i | iRPGenie

← Learning Center

SQLRPGLE

29 of 33 in this topic

SQL on IBM i · Query Optimization Basics

← Previous Next →

32Basic SELECT on IBM i
113What is SQLRPGLE?
114Native RPGLE File I/O vs Embedded SQL
115Basic EXEC SQL Syntax in RPGLE
116Host Variables in SQLRPGLE
117SELECT INTO for Reading One Row
118Using SQL Cursor to Read Multiple Rows
119INSERT with Embedded SQL
120UPDATE and DELETE with Embedded SQL
121SQLCODE and SQLSTATE Basics in SQLRPGLE
122Handling No Row Found in SQLRPGLE
123FETCH Loop for Reading Multiple Rows
124Basic WHERE Conditions in Embedded SQL
125ORDER BY and Result Ordering
126Simple JOIN in SQLRPGLE
127NULL Handling Basics in SQLRPGLE
128Common SQLRPGLE Mistakes and Best Practices
241DDL on IBM i: CREATE TABLE, ALTER TABLE, and DROP TABLE
242SQL Indexes and Views on Db2 for i
243Constraints on IBM i: Primary Key, Foreign Key, Unique, and Check
244ACS Run SQL Scripts for IBM i Developers
245SQL Stored Procedures on IBM i
246External Stored Procedures with RPGLE
247SQL Triggers on IBM i
248User-Defined Functions on IBM i
249SQLCA, SQLCODE, and SQLSTATE in Depth
250Static SQL vs Dynamic SQL on IBM i
251SQL Precompilation with CRTSQLRPGI
252Query Optimization Basics on Db2 for i
253SQE vs CQE at a Beginner-Friendly Level
254Encoded Vector Indexes Introduction
255DRDA and Distributed Database Concepts
256Common Advanced SQL Mistakes on IBM i

Lessons in SQLRPGLE

32Basic SELECT on IBM i
113What is SQLRPGLE?
114Native RPGLE File I/O vs Embedded SQL
115Basic EXEC SQL Syntax in RPGLE
116Host Variables in SQLRPGLE

Lesson 252 of 288

SQL on IBM i

Query Optimization Basics on Db2 for i

What a query optimizer does conceptually, and how indexes and access paths influence its choice of access plan.

~8 min read

Log in to continue

Create a free account to read this lesson and save your progress through the IBM i Fundamentals path.

Log in Create account

117

SELECT INTO for Reading One Row

118Using SQL Cursor to Read Multiple Rows

119INSERT with Embedded SQL

120UPDATE and DELETE with Embedded SQL

121SQLCODE and SQLSTATE Basics in SQLRPGLE

122Handling No Row Found in SQLRPGLE

123FETCH Loop for Reading Multiple Rows

124Basic WHERE Conditions in Embedded SQL

125ORDER BY and Result Ordering

126Simple JOIN in SQLRPGLE

127NULL Handling Basics in SQLRPGLE

128Common SQLRPGLE Mistakes and Best Practices

241DDL on IBM i: CREATE TABLE, ALTER TABLE, and DROP TABLE

242SQL Indexes and Views on Db2 for i

243Constraints on IBM i: Primary Key, Foreign Key, Unique, and Check

244ACS Run SQL Scripts for IBM i Developers

245SQL Stored Procedures on IBM i

246External Stored Procedures with RPGLE

247SQL Triggers on IBM i

248User-Defined Functions on IBM i

249SQLCA, SQLCODE, and SQLSTATE in Depth

250Static SQL vs Dynamic SQL on IBM i

251SQL Precompilation with CRTSQLRPGI

252Query Optimization Basics on Db2 for i

253SQE vs CQE at a Beginner-Friendly Level

254Encoded Vector Indexes Introduction

255DRDA and Distributed Database Concepts

256Common Advanced SQL Mistakes on IBM i

Have a question?

The AI Tutor is for educational guidance only. It cannot connect to a real IBM i system, execute code, or analyze production code. Opening it from here shares this lesson's title and content so it can answer questions about it directly, without leaving this page.

Try asking: “Can you walk me through, conceptually, why a missing index might make a query slower without the query itself being wrong?”

Practice this topic

←SQL Precompilation with CRTSQLRPGI SQE vs CQE at a Beginner-Friendly Level→