DB2 9 Fundamentals: Certification Study Guide

QMF interface, 51

Qualifier, schemas and, 192, 193, 418

Queries, 255, 265

Data Partition Elimination and, 416

ENABLE QUERY OPTIMIZATION and, 407

indexes and, 210

optimizing, informational constraints and, 374, 397–398, 398, 605

partitioned tables and, 416

SELECT and, 265

set operators and combined results using, 306–314

sub-, 277, 289

Query By Image Content (QBIC), 56

Query optimizer, 11. See also Optimizer

Query Parallelism, 39

Query Patroller (QP), 13, 14, 39, 47

Query User, authorities and privileges using, 150t

Query Workload Management, 14

Question panel, IBM Certification exam, 22–23, 22

Quiesce table space, 107, 109, 112

QUIESCE_CONNECT, 113