oracle tuning

Automatic Workload Repository - ?

Automatic Database Diagnostic Monitor - (ADDM) analyzes information in the AWR and provides recommendations on database performance issues including high resource-consuming SQL statements.

Enterprise Manager - ?

SQL Plan Management - ?

SQL Tuning Advisor - ? SQL Access Advisor - ? SQL Performance Advisor - ?

SQL tuning set (STS) - is a database object that contains one or more SQL statements and the associated execution statistics.

SQL Management Base - ? bind-peeking

NDV - number of distinct values

With just basic statistics we see the optimizer thinks there will only be 127 row returned because it assumes both columns will reduce the number of rows returned (# of rows in the table X 1/NDV of column1 X 1/NDV of column2)