Home
Home
Help
Help
Contact us
Contact Us

Oracle Database Search Results: first_rows

Oracle Database 11g Release 2 (11.2) documentation All of Oracle.com

Results 1 to 10 of about 36 for first_rows.

Topic Types
Emphasize concepts
Emphasize tasks
Emphasize examples
Job Roles
Emphasize administration topics
Emphasize application development topics
Top Matching Books
  1. Text Application Developer's Guide
  2. Performance Tuning Guide
  3. Data Cartridge Developer's Guide
  4. Concepts
  5. SQL Language Reference
  6. Data Warehousing Guide
  7. Spatial Developer's Guide
Example Example 7-4 Execution Plan for SELECT with FIRST_ROWS Hint
Example 7-4 Execution Plan for SELECT with FIRST_ROWS Hint SELECT /*+ FIRST_ROWS(25) */ employee_id department_id FROM hr.employees WHERE department_id > 50; ------------------------------------------------------------------------ | Id | Operation
ConceptsSearch this bookHide this bookContentsPDF
FIRST_ROWS Hint
FIRST_ROWS Hint Description of first_rows_hint.gif follows Description of the illustration first_rows_hint.gif The FIRST_ROWS hint instructs Oracle to optimize an individual SQL statement for fast response choosing the plan that returns the first n rows
SQL Language ReferenceSearch this bookHide this bookContentsPDF
FIRST_ROWS(n)
This hint instructs Oracle Database to optimize an individual SQL statement with a goal of best response time to return the first n number of rows where n equals any positive integer. The hint uses a cost-based approach for the SQL statement regardless
Performance Tuning GuideSearch this bookHide this bookContentsPDF
SDO_NN_DISTANCE Performance Improvement with FIRST_ROWS Hint
SDO_NN_DISTANCE Performance Improvement with FIRST_ROWS Hint The implementation of the SDO_NN_DISTANCE ancillary operator has been changed to provide improved performance when you specify the FIRST_ROWS optimizer hint. For an example of using the FIRST_ROWS
Spatial Developer's GuideSearch this bookHide this bookContentsPDF
FIRST_ROWS(n) Mode
7.2.2 FIRST_ROWS(n) Mode In FIRST_ROWS(n) mode the optimizer in Oracle Database optimizes for fast response time by having the Text domain index return score-sorted rows if possible. This is the default behavior when you use the FIRST_ROWS(n) hint.
Text Application Developer's GuideSearch this bookHide this bookContentsPDF
Improved Response Time with FIRST_ROWS(n) Hint for ORDER BY Queries
7.1.2 Improved Response Time with FIRST_ROWS(n) Hint for ORDER BY Queries When you need the first rows of an ORDER BY query Oracle recommends that you use the cost-based FIRST_ROWS(n) hint. You use the FIRST_ROWS(n) hint in cases where you want the first
Text Application Developer's GuideSearch this bookHide this bookContentsPDF
DRG-10840: CONTAINS predicate including 0 is not supported by FIRST_ROWS hint
DRG-10840: CONTAINS predicate including 0 is not supported by FIRST_ROWS hint Cause: User attempts to issue a query with CONTAINS predicate including 0 while giving FIRST_ROWS hint. Action: remove FIRST_ROWS hint.
Error MessagesSearch this bookHide this bookContentsPDF
Hints for Optimization Approaches and Goals
19.1.2.1 Hints for Optimization Approaches and Goals The ALL_ROWS and FIRST_ROWS( n ) hints let you choose between optimization approaches and goals. If a SQL statement has a hint specifying an optimization approach and goal then the optimizer uses the
Performance Tuning GuideSearch this bookHide this bookContentsPDF
Example Sample TKPROF Body
21.6.2 Sample TKPROF Body call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ --------
Performance Tuning GuideSearch this bookHide this bookContentsPDF
ALL_ROWS Hint
ALL_ROWS Hint Description of all_rows_hint.gif follows Description of the illustration all_rows_hint.gif The ALL_ROWS hint instructs the optimizer to optimize a statement block with a goal of best throughput which is minimum total resource consumption.
SQL Language ReferenceSearch this bookHide this bookContentsPDF

Result page: 1 2  3  4   Next >>