You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for hint


1 to 20 of 607 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database SQL Language Reference

Comments

HASH HintDescription of the illustration ''hash_hint.gif'' (See \"Specifying a Query Block in a Hint … \", tablespec::= ) The HASH hint instructs the optimizer to use a hash scan to access the specified table. This hint applies only to tables in a hash cluster.

Database SQL Language Reference

Comments

INDEX_SS_DESC HintHint\", tablespec::=, indexspec::= ) The INDEX_SS_DESC hint instructs the optimizer to perform an … hint effectively cancels out the descending order, resulting in a scan of the index entries in … ascending order. Each parameter serves the same purpose as in the \"INDEX Hint\". For example: SELECT

Database SQL Language Reference

Comments

NO_PUSH_PRED HintDescription of the illustration ''no_push_pred_hint.gif'' (See \"Specifying a Query Block in a Hint … \", tablespec::= ) The NO_PUSH_PRED hint instructs the optimizer not to push a join predicate into

Database SQL Language Reference

Comments

NO_PX_JOIN_FILTER HintDescription of the illustration ''no_px_join_filter_hint.gif'' This hint prevents the optimizer from using parallel join bitmap filtering.

Database SQL Language Reference

Comments

NO_STAR_TRANSFORMATION Hintin a Hint\" ) The NO_STAR_TRANSFORMATION hint instructs the optimizer not to perform star query transformation.

Database SQL Language Reference

Comments

UNNEST HintDescription of the illustration ''unnest_hint.gif'' (See \"Specifying a Query Block in a Hint … \" ) The UNNEST hint instructs the optimizer to unnest and merge the body of the subquery into the body of … statement is valid. The statement must then pass heuristic and query optimization tests. The UNNEST hint

Database SQL Language Reference

Comments

APPEND_VALUES HintDescription of the illustration ''append_values_hint.gif'' The APPEND_VALUES hint instructs the … optimizer to use direct-path INSERT with the VALUES clause. If you do not specify this hint, then … considerably faster than conventional INSERT. The APPEND_VALUES hint can be used to greatly enhance … FORALL loop that has an INSERT

Database SQL Language Reference

Comments

DYNAMIC_SAMPLING HintHint\", tablespec::= ) The DYNAMIC_SAMPLING hint instructs the optimizer how to control dynamic … the existing statistics and ignores this hint. For example, the following query will not result in … sampling to a specific table, use the following form of the hint: SELECT /*+ DYNAMIC_SAMPLING

Database SQL Language Reference

Comments

INDEX HintDescription of the illustration ''index_hint.gif'' (See \"Specifying a Query Block in a Hint … \", tablespec::=, indexspec::= ) The INDEX hint instructs the optimizer to use an index scan for the … specified table. You can use the INDEX hint for function-based, domain, B-tree, bitmap, and bitmap join … indexes. The behavior of

Database SQL Language Reference

Comments

INDEX_ASC HintDescription of the illustration ''index_asc_hint.gif'' (See \"Specifying a Query Block in a Hint … \", tablespec::=, indexspec::= ) The INDEX_ASC hint instructs the optimizer to use an index scan for … \"INDEX Hint\". The default behavior for a range scan is to scan index entries in ascending order of … their indexed values, or

Database SQL Language Reference

Comments

INDEX_SS_ASC HintDescription of the illustration ''index_ss_asc_hint.gif'' (See \"Specifying a Query Block in a Hint … \", tablespec::=, indexspec::= ) The INDEX_SS_ASC hint instructs the optimizer to perform an index … \"INDEX Hint\". The default behavior for a range scan is to scan index entries in ascending order of … their indexed values,

Database SQL Language Reference

Comments

NOAPPEND HintDescription of the illustration ''noappend_hint.gif'' The NOAPPEND hint instructs the optimizer to

Database SQL Language Reference

Comments

NO_INDEX_FFS HintDescription of the illustration ''no_index_ffs_hint.gif'' (See \"Specifying a Query Block in a Hint … \", tablespec::=, indexspec::= ) The NO_INDEX_FFS hint instructs the optimizer to exclude a fast … purpose as in the \"NO_INDEX Hint\". For example: SELECT /*+ NO_INDEX_FFS(items item_order_ix) */ order_id FROM order_items items;

Database SQL Language Reference

Comments

NO_MONITOR HintDescription of the illustration ''no_monitor_hint.gif'' The NO_MONITOR hint disables real-time SQL

Database SQL Language Reference

Comments

NOPARALLEL HintThe NOPARALLEL hint has been deprecated. Use the NO_PARALLEL hint instead.

Database SQL Language Reference

Comments

NO_USE_MERGE HintDescription of the illustration ''no_use_merge_hint.gif'' (See \"Specifying a Query Block in a Hint … \", tablespec::= ) The NO_USE_MERGE hint instructs the optimizer to exclude sort-merge joins when

Database SQL Language Reference

Comments

STATEMENT_QUEUING HintDescription of the illustration ''statement_queuing_hint.gif'' The NO_STATEMENT_QUEUING hint … PARALLEL_DEGREE_POLICY is not set to AUTO, this hint enables a statement to be considered for parallel statement queuing … emp.department_id = dpt.department_id; See Also: \"NO_STATEMENT_QUEUING Hint\"

Database SQL Language Reference

Comments

CURSOR_SHARING_EXACT HintCURSOR_SHARING initialization parameter. The CURSOR_SHARING_EXACT hint instructs the optimizer to … switch this behavior off. When you specify this hint, Oracle executes the SQL statement without any attempt to replace literals with bind variables.

Database SQL Language Reference

Comments

MODEL_MIN_ANALYSIS HintDescription of the illustration ''model_min_analysis_hint.gif'' The MODEL_MIN_ANALYSIS hinthint reduces compilation time because spreadsheet analysis can be lengthy if the number of spreadsheet rules is more than several hundreds.

Database SQL Language Reference

Comments

NOCACHE HintDescription of the illustration ''nocache_hint.gif'' (See \"Specifying a Query Block in a Hint … \", tablespec::= ) The NOCACHE hint instructs the optimizer to place the blocks retrieved for the table