Oracle SQL Hints --- Contents
[中文]
Author:
fuyuncat
Source:
www.HelloDBA.com
Date:
2013-01-16 00:38:03
Share to
SQL Hint is one of most important approaches to change the activity of optimizer and SQL execution, it’s also pretty important for SQL tuning. For instance, HINT is a part of the SQL Profiler advised by SQL Tuning Advisor. In each Oracle version, corresponding to the SQL features changes, new hints will be introduced, and old hints may be obsolete.
Contents:
- Oracle SQL Hints --- Abstraction
- Oracle SQL Hints --- Access Path Hints
- Oracle SQL Hints --- Join Hints
- Oracle SQL Hints --- Outline Data Hints
- Oracle SQL Hints --- Query Transformation Hints
- Oracle SQL Hints --- Statistics Data And Optimizer Hints
- Oracle SQL Hints --- Run Time And Data Maniplulation Hints
- Oracle SQL Hints --- Hierarchy Query And XML Query Hints
- Oracle SQL Hints --- Distributed Query And Parallel Query Hints
- Oracle SQL Hints --- Model Query And Partition Hints
- Oracle SQL Hints --- Other Hints