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