Index
A
Automated SQL tuning
architecture, 208
DBMS_AUTO_SQLTUNE package, 209
e-mailing tuning advice, 210
ENABLE/DISABLE procedure, 212–214
maintenance window, 208
REPORT_AUTO_TUNING_TASK function, 210
SCRIPT_TUNING_TASK function, 212
Automatic Workload Repository (AWR), 206, 214–216, 218–219
B
advantages, 67
benefits, 56
bitmap join indexes
benefits, 63
geography dimension (GEO_ID), 64
index creation, 66
composite bitmap index, 51
data dictionary, 66
DML mechanism, 62
drawbacks, 67
drawbacks and limitations, 49
GENDER ...
Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
