Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Miscellaneous hints

The following hints cover other types of optimization choices:

APPEND

Enables direct-path INSERTs if you are running in serial mode (i.e., you are not running Enterprise Edition).

NOAPPEND

Disables direct-path INSERTs for the statement.

CACHE( table )

Places table in the buffer cache at the most recently used end of the least recently used (LRU) list when a full table scan is performed, as for a small lookup table.

NOCACHE

Places table in the buffer cache at the least recently used end of the LRU list when a full table scan is performed. With Oracle9i Release 2, small tables are automatically cached.

UNNEST

Specifies that a subquery is merged with the parent query. This hint is new with Oracle9i.

NO_UNNEST

Turns off UNNEST for specific query blocks. This hint is new with Oracle9i.

PUSH_PRED( table )

Pushes a join predicate into a view. This hint was called PUSH_JOIN_PRED in Oracle8.

NO_PUSH_PRED( table )

Prevents pushing a join predicate into a view. This hint was called NO_PUSH_JOIN_PRED in Oracle8.

PUSH_SUBQ

Forces nonmerged subqueries to be evaluated at the earliest possible step in the optimization process. Appropriate if the subquery is inexpensive and limits the number of rows evaluated.

NO_PUSH_SUBQ

Forces nonmerged subqueries to be evaluated at the earliest possible step in the optimization process. New with Oracle9i.

ORDERED_PREDICATES

Forces optimizer to preserve the order of the predicates in the WHERE clause. This hint is specified in the WHERE clause. New ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page