Home
Home
Customize
Customize
Help
Help
Contact us
Contact Us

Oracle Database Search Results: ORDER

Results 1 to 10 of about 170 for ORDER.

Refine Results
Related concepts (12)
Related tasks (28)
Related examples (37)
Filter by Job Role
Related administration topics (100)
Related application development topics (54)
Top Matching Books
Error Messages (53)
Application Developer's Guide - Object-Relational Features (18)
XML DB Developer's Guide (13)
Data Warehousing Guide (9)
Utilities (8)
Streams Advanced Queuing User's Guide and Reference (7)
Application Developer's Guide - Fundamentals (6)
Performance Tuning Guide (5)
Text Application Developer's Guide (4)
Advanced Replication (3)
Task Using the ORDER BY Clause with Index-Organized Tables
If an ORDER BY clause only references the primary key column or a prefix of it, then the optimizer avoids the sorting overhead, as the rows are returned sorted on the primary key columns.
Administrator's GuideSearch this bookHide this bookContentsPDF
Task Ordering of Triggers
A relational database does not guarantee the order of rows processed by a SQL statement.
Application Developer's Guide - FundamentalsSearch this bookHide this bookContentsPDF
Task Controlling the Access Path and Join Order with Hints
You can influence the optimizer's choices by setting the optimizer approach and goal, and by gathering representative statistics for the query optimizer.
Performance Tuning GuideSearch this bookHide this bookContentsPDF
Order Index Columns for Performance
Administrator's GuideSearch this bookHide this bookContentsPDF
Hints for Join Orders
Performance Tuning GuideSearch this bookHide this bookContentsPDF
Concept Column Order
ConceptsSearch this bookHide this bookContentsPDF
Task Entering a Buy Order
In this example, illustrated by Figure 5-6, a customer enters a buy order.
Application Developer's Guide - FundamentalsSearch this bookHide this bookContentsPDF
Task Ordering Columns in an Index
Designers should be flexible in defining any rules for index building.
Performance Tuning GuideSearch this bookHide this bookContentsPDF
Task Ordering Keys for Composite Indexes
Follow these guidelines for ordering keys in composite indexes:
Performance Tuning GuideSearch this bookHide this bookContentsPDF
Choose the Order of Columns in Composite Indexes
Although you can specify columns in any order in the CREATE INDEX command, the order of columns in the CREATE INDEX statement can affect query performance.
Application Developer's Guide - FundamentalsSearch this bookHide this bookContentsPDF

Result page: 1 2  3  4  5  6  7  8  9  10   Next >>