Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
what is the use of "ORDER BY VALUES"
- Thread starter ChandruN
- Start date
rrrkrishnan
Programmer
Value ordered indexes are very efficient for range conditions. The rows in the index subtable are sorted by the column that you specify in the order by values clause. So this makes it possible to search only a portion of the index sub table when processing range conditions.
The column that you specify in the order by clause can be a single numberic column that cannot exceed 4 bytes, dates are allowed too.
The column that you specify in the order by clause can be a single numberic column that cannot exceed 4 bytes, dates are allowed too.
- Status
Similar threads
- Locked
- Question
- Locked
- Question