Index

A B C D E F G H I J K L M N O P Q R S T U V

access method

bitmap processing access (834)

hashing access (831)

index only access (821)

index scan-key positioning (815)

index scan-key selection (809)

index-from-index (827)

parallel index scan-key positioning (818)

parallel index scan-key selection access method (812)

parallel preload (824)

parallel table prefetch (800)

parallel table scan (806)

row selection method (784)

sort access (837)

summary table (791)

table scan (792)

access path

definition (776)

index (782)

sequential (779)

access plan

validation (856)

access plan rebuilt

summary row (1142)

advisor

query optimizer index (957)

ALLOCATE clause

performance implications (1119)

allow copy data (ALWCPYDTA) parameter (1023)

ALWCPYDTA (allow copy data) parameter (1022)

ALWCPYDTA parameter

effect on query optimimizer (848)

bitmap created

summary row (1157)

bitmap merge

summary row (1159)

bitmap processing access method (833)

blocking consideration

using, affect on performance (1091)

blocking, SQL

improving performance (1080)

calls, number

using

FETCH statement (1073)

cancelling a query (988)

Change Query Attribute (CHGQRYA) command (801)

Change query attributes (972)

Change Query Attributes (CHGQRYA) command (898)

changing

query options file (982)

CHGQRYA (Change Query Attributes) command (897)

CLOSQLCSR parameter

using (1069)

command

CHGQRYA (973)

CHGQRYA command (974)

QAQQINI (976)

QAQQINI command (977)

command (CL)

Change Query Attribute (CHGQRYA) command (802)

Change Query Attributes (CHGQRYA) (900)

CHGQRYA (Change Query Attribute) command (803)

CHGQRYA (Change Query Attributes) (899)

Delete Override (DLTOVR) (1038)

Display Job (DSPJOB) (905)

Display Journal (DSPJRN) (1045)

DLTOVR (Delete Override) (1039)

DSPJOB (Display Job) (904)

DSPJRN (Display Journal) (1047)

Override Database File (OVRDBF) (1035), (1082), (1092)

OVRDBF (Override Database File) (1036), (1083), (1093)

Print SQL Information (PRTSQLINF) (909), (1000)

QAQQINI (983)

Start Database Monitor (STRDBMON) (913)

STRDBMON (Start Database Monitor) (912)

Trace Job (TRCJOB) (917), (1044)

TRCJOB (Trace Job) (916), (1046)

commands

End Database Monitor (ENDDBMON) (950)

Start Database Monitor (STRDBMON) (944)

commitment control

displaying (907)

controlling parallel processing (1004)

copy of the data

using to improve performance (1116)

cost estimation

query optimizer (845)

cursor

positions

retaining across program call (1052), (1061)

rules for retaining (1053)

using to improve performance (1054), (1062)

data

paging

interactively displayed to improve performance (1105)

selecting from multiple tables

affect on performance (885)

data path, open (929)

database monitor

end (947)

examples (958), (970)

logical file DDS (1124)

physical file DDS (1121)

start (945)

database monitor performance rows (951)

database query performance

monitoring (939)

dataspace

definition (787)

DDS

database monitor logical file (1126)

database monitor physical file (1123)

default filter factors (853)

definitions

access path (775)

bitmap processing method (832)

dataspace (786)

default filter factors (854)

dial (866)

hashing access method (829)

implementation cost (847)

index (780)

index only access method (819)

index scan-key positioning access method (813)

index scan-key selection access method (807)

index-from-index access method (825)

isolatable (878)

miniplan (857)

open data path (928)

parallel index scan-key positioning access method (816)

parallel index scan-key selection access method (810)

parallel table prefetch access method (798)

parallel table scan method (804)

primary table (864)

secondary tables (865)

sort access method (835)

symmetrical multiprocessing (788)

table scan (777)

Delete Override (DLTOVR) command (1037)

deleted rows

getting rid of using REUSEDLT(*YES) (797)

getting rid of using RGZPFM (796)

detail row

rows retrieved (1154)

Display Job (DSPJOB) command (903)

Display Journal (DSPJRN) command (1043)

distinct processing

summary row (1163)

DSPJOB (Display Job) command (902)

End Database Monitor (ENDDBMON) command (946)

ENDDBMON (end database monitor) command (949)

examples

database monitor (959), (971)

governor (1001)

index (1008)

performance analysis (961), (965), (969)

reducing the number of open database operation (1033)

selecting data from multiple tables (888)

file

query options (979)

filter factors, default

in query optimization (852)

generic query information

summary row (1151)

governor (984)

*DFT (995)

*RQD (996)

*SYSRPYL (997)

CHGQRYA (987)

JOB (990)

QRYTIMLMT (986)

time limit (992)

grouping

summary row (1169)

grouping optimization (889)

hash join (867)

hash table

summary row (1161)

hashing access method (830)

host variable and ODP implementation

summary row (1148)

improving performance (1020), (1112)

blocking, using (1089)

join queries (881)

paging interactively displayed data (1101)

PREPARE statement (1097)

retaining cursor positions across program call (1049), (1058)

SELECT statements, using effectively (1094)

selecting data from multiple tables (882)

SQL blocking (1077)

using

close SQL cursor (CLOSQLCSR) (1048), (1057)

FETCH FOR n ROWS (1071)

INSERT n ROWS (1084)

parameter passing techniques (1012)

precompile options (1108)

index

access path (781)

columns used for keys (783)

creating

from another index (826)

temporary keyed

from index (875)

from the table (873)

using effectively, example (1007)

index advisor

query optimizer (956)

index created

summary row (1134)

index only access method (820)

index ordering

summary row (1171)

index scan-key positioning

access method (814)

index scan-key selection

access method (808)

index-from-index

access method (828)

indexes

using with sort sequence (1009)

information messages

open data path (933), (936)

performance (921), (925)

INSERT n ROWS

improving performance (1086)

interactively displayed data, paging

affect on performance (1104)

JOB (991)

join

hash (868)

optimization (860)

join optimization

performance tips (880)

join order

optimization (869)

join position (923)

join secondary dials

costing (871)

key range estimate (855)

limit, time (993)

live data

using to improve performance (1025)

locks

analyzing (906)

logical file DDS

database monitor (1125)

long object names

performance (1107)

message

cause and user response (919)

open data path information (934), (937)

performance information (922), (926)

running in debug mode (918)

monitor (ENDDBMON) command, end database (948)

monitoring

database query performance (938)

multiple

table

improving performance when selecting data from (886)

nested loop join (863)

number of calls

using a FETCH statement (1075)

number of open database operations

improving performance by reducing (1032)

ODP implementation and host variable

summary row (1149)

open

closing (1040)

determing number (1041)

effect on performance (1031)

reducing number (1030)

open data path

definition (927)

information messages (931)

OPNQRYF (Open Query File) command (891)

optimization (839)

grouping (890)

join (861)

join order (870)

nested loop join (862)

OPTIMIZE FOR n ROWS clause

effect on query optimizer (849)

optimizer

operation (843)

query index advisor (955)

optimizer timed out

summary row (1144)

options, precompile

improving performance by using (1111)

output

all queries that performed table scans (966)

SQL queries that performed table scans (962)

Override Database File (OVRDBF) command (1034), (1081)

page fault (785)

paging

interactively displayed data (1102)

parallel index scan-key positioning access method (817)

parallel index scan-key selection access method (811)

parallel preload

index-based (823)

table-based (822)

parallel processing

controlling

in jobs (CHGQRYA command) (1006)

system wide (QQRYDEGREE) value (1005)

parallel table prefetch

access method (799)

parallel table scan

access method (805)

parameter passing

differences (1015)

parameters, command

ALWCPYDTA (allow copy data) (1021), (1117)

CLOSQLCSR (close SQL cursor) (1055), (1063)

path, open data (930)

performance (840)

information messages (920), (924)

monitoring (893)

monitoring query (941)

open data path messages (932), (935)

OPNQRYF (892)

optimizing (894)

tools (896)

using long object names (1106)

performance analysis

example 1 (960)

example 2 (964)

example 3 (968)

performance considerations (998), (1027)

performance improvement

blocking, using (1090)

paging interactively displayed data (1103)

PREPARE statement (1098)

reducing number of open database operation (1029)

retaining cursor positions across program call (1051), (1060)

SELECT statements, using effectively (1095)

selecting data from multiple tables (884)

SQL blocking (1078)

using copy of the data (1115)

using INSERT n ROWS (1085)

using live data (1024)

using precompile options (1109)

performance rows

database monitor (952)

physical file DDS

database monitor (1122)

pre-fetching (794)

precompile options

improving performance, using (1110)

precompiler

passing

host variables (1011), (1014)

precompiler command

default (1056), (1064)

precompiler parameter

ALWCPYDTA (1026)

CLOSQLCSR (1070)

predicate

transitive closure (876)

Predictive Query Governor (985)

PREPARE statement

improving performance (1099)

Print SQL Information (PRTSQLINF) (908), (999)

problems

join query performance (879)

program calls

rules for retaining cursor positions (1067)

QAQQINI (981)

QDT (859)

QRYTIMLMT parameter

CHGQRYA (Change Query Attributes) command (901)

query

cancelling (989)

Query Definition Template (QDT) (858)

query optimizer (838)

cost estimation (846)

decision-making rules (844)

default filter factors (851)

optimization goals (850)

query optimizer index advisor (954)

query options

file (980)

Query options file (975)

query options file

changing (978)

query performance

monitoring (940)

query sort

summary row (1136)

query step processing

summary row (1173)

query time limit (994)

reducing number of open database operations

improving performance, example (1028)

Reorganize Physical File Member (RGZPFM) command

effect on variable-length columns (1120)

getting rid of deleted rows (795)

resource

optimization (842)

retaining cursor positions

across program call

improving performance (1050), (1059)

all program calls

rules (1066)

rows

database monitor performance (953)

rows retrieved

detail row (1155)

ROWS, INSERT n

improving performance (1087)

rule

retaining cursor positions

program calls (1065)

SELECT statement

using effectively to improve performance (1096)

selecting

data from multiple tables (883)

setting query time limit (1002)

sort access method (836)

sort sequence

using indexes (1010)

SQL blocking

improving performance (1079)

SQL information

summary row (1128), (1175)

Start Database Monitor (STRDBMON) command (911), (942)

statements

FETCH

FOR n ROWS (1072)

number of calls (1076)

INSERT

n ROWS (1088)

PREPARE

improving performance (1100)

STRDBMON (Start Database Monitor) command (910), (943)

STRDBMON/ENDDBMON commands

summary row (1153)

structure parameter passing (1016)

subquery merge

summary row (1167)

subquery processing

summary row (1146)

summary row

access plan rebuilt (1141)

bitmap created (1156)

bitmap merge (1158)

distinct processing (1162)

generic query information (1150)

grouping (1168)

hash table (1160)

host variable and ODP implementation (1147)

index created (1133)

index ordering (1170)

optimizer timed out (1143)

query sort (1135)

query step processing (1172)

SQL information (1127)

STRDBMON/ENDDBMON commands (1152)

subquery merge (1166)

subquery processing (1145)

table locked (1139)

table scan (1129)

temporary table (1137)

union merge (1164)

using existing index (1131)

summary rows

SQL information (1174)

using existing index (1176), (1178), (1180), (1182), (1184) , (1186), (1188), (1190), (1192)

symmetrical multiprocessing (789)

table

data management methods (790)

multiple

improving performance when selecting data from (887)

table locked

summary row (1140)

table scan (778)

access method (793)

summary row (1130)

table scans

output for all queries (967)

output for SQL queries (963)

temporary index (872), (874)

temporary table

summary row (1138)

tools

performance (895)

Trace Job (TRCJOB) command (915), (1042)

transitive closure (877)

TRCJOB (Trace Job) command (914)

union merge

summary row (1165)

using

a copy of the data (1017), (1113)

allow copy data (ALWCPYDTA) (1018), (1114)

close SQL cursor (CLOSQLCSR) (1019), (1068)

FETCH statement (1074)

parameter passing techniques

performance improvement (1013)

using existing index

summary row (1132), (1177), (1179), (1181), (1183) , (1185), (1187), (1189), (1191), (1193)

using JOB parameter (1003)

using SQL

application programs (841)

variable-length data

tips (1118)

[ Top of Page | Previous Page | Table of Contents | Index ]