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, 11g Release 2 (11.2)

Comments

CACHE HintDescription of the illustration ''cache_hint.gif'' (See \"Specifying a Query Block in a Hint … \", tablespec::= ) The CACHE hint instructs the optimizer to place the blocks retrieved for the table at … . This hint is useful for small lookup tables. In the following example, the CACHE hint overrides the

Database SQL Language Reference, 11g Release 2 (11.2)

Comments

CHANGE_DUPKEY_ERROR_INDEX Hinthints. The CHANGE_DUPKEY_ERROR_INDEX hint provides a mechanism to unambiguously identify a unique key … occurs for the specified index, an ORA-38911 error is reported instead of an ORA-001. This hint applies … columns in number and order must exist. This use of this hint results in error messages if specific … rules are violated.

Database SQL Language Reference, 11g Release 2 (11.2)

Comments

FACT HintDescription of the illustration ''fact_hint.gif'' (See \"Specifying a Query Block in a Hint … \", tablespec::= ) The FACT hint is used in the context of the star transformation. It instructs the

Database SQL Language Reference, 11g Release 2 (11.2)

Comments

FULL HintDescription of the illustration ''full_hint.gif'' (See \"Specifying a Query Block in a Hint … \", tablespec::= ) The FULL hint instructs the optimizer to perform a full table scan for the specified … WHERE clause. The employees table has alias e in the FROM clause, so the hint must refer to the table … by its alias rather than

Database SQL Language Reference, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

Comments

MONITOR HintDescription of the illustration ''monitor_hint.gif'' The MONITOR hint forces real-time SQL … monitoring for the query, even if the statement is not long running. This hint is valid only when the

Database SQL Language Reference, 11g Release 2 (11.2)

Comments

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

Database SQL Language Reference, 11g Release 2 (11.2)

Comments

NO_RESULT_CACHE Hint, the NO_RESULT_CACHE hint disables such caching for the current query. If the query is executed from … OCI client and OCI client result cache is enabled, then the NO_RESULT_CACHE hint disables caching for the current query.

Database SQL Language Reference, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

Comments

NO_XML_QUERY_REWRITE HintDescription of the illustration ''no_xml_query_rewrite_hint.gif'' The NO_XML_QUERY_REWRITE hint … prohibiting the rewriting of XPath expressions, this hint also prohibits the use of any XMLIndexes for the … current query. For example: SELECT /*+NO_XML_QUERY_REWRITE*/ XMLQUERY('' RETURNING CONTENT) FROM DUAL; See Also: \"NO_XMLINDEX_REWRITE Hint\"

Database SQL Language Reference, 11g Release 2 (11.2)

Comments

PARALLEL_INDEX HintHint\", tablespec::=, indexspec::= ) The PARALLEL_INDEX hint instructs the optimizer to use the … following hint indicates three parallel execution processes are to be used: SELECT /*+ PARALLEL_INDEX

Database SQL Language Reference, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

Comments

INDEX_JOIN HintDescription of the illustration ''index_join_hint.gif'' (See \"Specifying a Query Block in a Hint … \", tablespec::=, indexspec::= ) The INDEX_JOIN hint instructs the optimizer to use an index join as … an access path. For the hint to have a positive effect, a sufficiently small number of indexes must … purpose as in \"INDEX Hint\".

Database SQL Language Reference, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

Comments

NO_INDEX_SS HintDescription of the illustration ''no_index_ss_hint.gif'' (See \"Specifying a Query Block in a Hint … \", tablespec::=, indexspec::= ) The NO_INDEX_SS hint instructs the optimizer to exclude a skip … \"NO_INDEX Hint\". See Also: Oracle Database Performance Tuning Guide for information on index skip scans

Database SQL Language Reference, 11g Release 2 (11.2)

Comments

NO_QUERY_TRANSFORMATION HintDescription of the illustration ''no_query_transformatn_hint.gif'' The NO_QUERY_TRANSFORMATION hint

Database SQL Language Reference, 11g Release 2 (11.2)

Comments

NO_STATEMENT_QUEUING HintDescription of the illustration ''no_statement_queuing_hint.gif'' The NO_STATEMENT_QUEUING hint … PARALLEL_DEGREE_POLICY is set to AUTO, this hint enables a statement to bypass the parallel statement queue. However … employees emp, departments dpt WHERE emp.department_id = dpt.department_id; See Also: \"STATEMENT_QUEUING Hint\"

Database SQL Language Reference, 11g Release 2 (11.2)

Comments

QB_NAME HintDescription of the illustration ''qb_name_hint.gif'' (See \"Specifying a Query Block in a Hint … \" ) Use the QB_NAME hint to define a name for a query block. This name can then be used in a hint in the … outer query or even in a hint in an inline view to affect query execution on the tables appearing … referencing

Database SQL Language Reference, 11g Release 2 (11.2)

Comments

RETRY_ON_ROW_CHANGE Hint… This hint is valid only for UPDATE and DELETE operations. It is not supported for INSERT or MERGE … operations. When you specify this hint, the operation is retried when the ORA_ROWSCN for one or more … the block is actually modified. See Also: IGNORE_ROW_ON_DUPKEY_INDEX Hint and … CHANGE_DUPKEY_ERROR_INDEX Hint