index_Q

Q

Queries

computing aggregates in, 176-77

conditions, 176

defining, 461

with multiple groupings, 191

with multiple materialized views, 191-93

OLAP, 13, 427

performance, 382

response times, determining, 398

specifying, 415

Query Builder, 416, 457, 461

Query optimization, 94-101

cost-based, 94

join, 97-101

rule-based, 94-95

Query rewrite, 170-96

aggregate rollup, 172-73

constraints and, 180-82

defined, 138

with dimensions, 177-80

enabling, 170

filtered data, 174-76

with GROUP BY clause, 190-91

grouping sets and, 190-93

integrity dependence, 186

integrity modes, 182-86

join-back, 173-74

with multiple groupings, 191

with multiple materialized views, 191-93

optimizer and, 186-87

PCT and, 187-89

problems, troubleshooting, 193-96

query identification, 171

SQL text match, 171-72

transformation support, 170

See also Summary Management

QUERY-REWRITE_INTEGRITY mode, 182-86

ENFORCED, 182, 183, 184, 185

STALE_TOLERATED, 182, 183, 185

TRUSTED, 182, 185, 186

Query Wizard, 465