select /*+ ALL_ROWS */ emplid, name, salary
where emplid = 8675309;
Below is a complete list of Oracle hints and a description of what each does.
Directs the optimizer to choose a cost-based execution plan that is designed to provide the best throughput (useful for batch processing)
Directs the optimizer to choose the best execution plan for retrieving the first row in a query (useful for online processing)
Forces a table scan by RowID for the specified table
Chooses a hash scan to access the specified table
forces usage of a specific index
causes the optimizer to join tables in the order specified in the FROM clause
Full Table Scans
If your explain plan indicates that full table scans are occurring, here are some basic coding hints for avoiding these full table scans.