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 first_rows


1 to 20 of 36 results. Previous page Prev  Next next page


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

Comments

Jump to FIRST_ROWS HintDescription of the illustration first_rows_hint.gif The FIRST_ROWS hint instructs Oracle to … /*+ FIRST_ROWS(10) */ employee_id, last_name, salary, job_id FROM

Database Concepts, 11g Release 2 (11.2)

SQL

Jump to Example 7-4 Execution Plan for SELECT with FIRST_ROWS HintSELECT /*+ FIRST_ROWS(25) */ employee_id, department_id FROM hr.employees WHERE department_id > 50

Text Application Developer's Guide, 11g Release 2 (11.2)

Tuning Oracle Text

Jump to 7.2.2 FIRST_ROWS(n) ModeIn FIRST_ROWS(n) mode, the optimizer in Oracle Database optimizes for fast response time by having … use the FIRST_ROWS(n) hint. If you want to optimize for better

Spatial Developer's Guide, 11g Release 2 (11.2)

What's New in Oracle Spatial?

Jump to SDO_NN_DISTANCE Performance Improvement with FIRST_ROWS Hintperformance when you specify the FIRST_ROWS optimizer hint. For an example of using the FIRST_ROWS

Database Performance Tuning Guide, 11g Release 2 (11.2)

The Query Optimizer

Jump to OPTIMIZER_MODE Sets the mode of the optimizer at instance startup. The possible values are ALL_ROWS…, FIRST_ROWS_ n, and FIRST_ROWS. For descriptions of these parameter values, see "Setting the OPTIMIZER_MODE Initialization Parameter".

Text Application Developer's Guide, 11g Release 2 (11.2)

Tuning Oracle Text

Jump to 7.1.2 Improved Response Time with FIRST_ROWS(n) Hint for ORDER BY QueriesFIRST_ROWS(n) hint. You use the FIRST_ROWS(n) hint in cases where you want the first number ( n ) of … cursor to retrieve the first 10 hits of a query and uses

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

Comments

Jump to ALL_ROWS Hintemployee_id = 107; If you specify either the ALL_ROWS or the FIRST_ROWS hint in a SQL statement, and if … FIRST_ROWS hint, then the optimizer gives precedence

Database Performance Tuning Guide, 11g Release 2 (11.2)

The Query Optimizer

Jump to Table 11-5 Hints for Changing the Query Optimizer GoalHint Description FIRST_ROWS( n ) This hint instructs Oracle Database to optimize an individual SQL

Database Performance Tuning Guide, 11g Release 2 (11.2)

Using Optimizer Hints

Jump to 19.1.2.1 Hints for Optimization Approaches and GoalsThe ALL_ROWS and FIRST_ROWS( n ) hints let you choose between optimization approaches and goals. If … statement does not affect SQL run within PL/SQL. If you specify either the

Database Concepts, 11g Release 2 (11.2)

SQL

Jump to Figure 7-4 Shared Pool CheckOPTIMIZER_MODE=FIRST_ROWS; SELECT * FROM my_table; ALTER SESSION SET SQL_TRACE=TRUE; SELECT * FROM my_table

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

Comments

Jump to Table 3-21 Hints by Functional CategoryHint Link to Syntax and Semantics Optimization Goals and Approaches ALL_ROWS Hint FIRST_ROWS Hint

Database Performance Tuning Guide, 11g Release 2 (11.2)

The Query Optimizer

Jump to 11.5.2.1 Setting the OPTIMIZER_MODE Initialization Parameterrows, where n equals 1, 10, 100, or 1000. FIRST_ROWS The optimizer uses a mix of cost and heuristics … plan without applying the heuristic. FIRST_ROWS is available

Database Concepts, 11g Release 2 (11.2)

SQL

Jump to Use of the Optimizeras possible. Initial response time The FIRST_ROWS hint instructs the optimizer to get the first row

Database Reference, 11g Release 2 (11.2)

OPTIMIZER_MODE

Jump to OPTIMIZER_MODE| 1000] | first_rows | all_rows } Default value all_rows Modifiable ALTER SESSION, ALTER SYSTEM … response time to return the first n rows (where n = 1, 10, 100, 1000). first_rows

Database Performance Tuning Guide, 11g Release 2 (11.2)

Using Optimizer Hints

Jump to 19.1 Overview of Optimizer Hintscost: SELECT /*+ FIRST_ROWS(10) */ * FROM employees; See Also: Oracle Database SQL Language Reference

Database Performance Tuning Guide, 11g Release 2 (11.2)

Using Application Tracing Tools

Jump to 21.6.2 Sample TKPROF Body0.00 0 0 0 0 Misses in library cache during parse: 1 Optimizer mode: FIRST_ROWS Parsing user id: 44 … ------- ------ -------- ---------- ---------- ---------- ---------- ----------

Text Application Developer's Guide, 11g Release 2 (11.2)

Tuning Oracle Text

Jump to 7.7.9 How do I make an ORDER BY score query faster?Answer: Sorting by relevance ( SCORE(n) ) can be extremely quick if the FIRST_ROWS(n) hint is used … tables. An example of such a query: SELECT /*+ FIRST_ROWS(10)

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Query Rewrite

Jump to Initialization Parameters for Query Rewrite: OPTIMIZER_MODE = ALL_ROWS (default), FIRST_ROWS, or FIRST_ROWS_ n With OPTIMIZER_MODE set to FIRST_ROWS, the

Text Application Developer's Guide, 11g Release 2 (11.2)

Querying with Oracle Text

Jump to 4.2.9 Optimizing for Response Timeout. This example uses the FIRST_ROWS (n) hint and a cursor. declare cursor c is select … /*+ FIRST_ROWS(20) */ title, score(1) score from news where contains(txt_col,

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Query Rewrite

Jump to Ensuring that Query Rewrite Takes EffectOPTIMIZER_MODE to ALL_ROWS, FIRST_ROWS, or FIRST_ROWS_ n. If step 1 has not been completed, a