Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

(click on this box to dismiss)

Does the hint "USE_DESC_IDX" applies to multiple indexes at the same time?

The page in manual doesn't mention anything about multiple indexes. Suppose I join two tables, and I have an index on a column from each of the tables. Then is this hint applied to both index scans? Or can it be applied only on one of the scans, and not on the other?

select /*+ USE_DESC_IDX */ ... from t1,t2 where ... using index index1(+), index2(+)

In this query, do both index scans are descending? Can I make one descending and one normal?

link comment (0) accepted answer
asked 4 years ago
5 Answers

USE_DESC_IDX applies to all index scans in the query.

link comment (0)
answered 4 years ago

You are either using a very old browser or a browser that is not supported.
In order to browse you need to have one of the following browsers:

Internet Explorer: Mozilla Firefox: Google Chrome: