11g New Features:

11g New Features:

1. Adaptive Cursor sharing.

2.Adaptive Direct Path Reads.

3.adrci utility for the purge the trace files.

$ adrci
adrci> help

4. SCAN Ip  for simplified Cilent Access

5.Automatic restart of single instance.

6.SRVCTL support for single instance.

7. Real Application testing - Database replay

8.Active Datagaurd.

Why is my index not being used?

Why is my index not being used?

1. where surname != 'FRASER'
2. where upper(surname) = 'FRASER'
3. where surname is null
4. where surname like '%FRASER'
5. small tables
6. histograms:
   
   90% rows 'Yes'
   1% rows 'No'
   1% 'Maybe'
   1% 'Not in'
   1% 'Later'
   where answer = 'Yes'

----> IN is faster than EXISTS for subqueries that return few rows.
----> EXISTS is faster than IN for subqueries that return many rows.