Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


3
(click on this box to dismiss)

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

The page in manual http://www.cubrid.org/manual/840/en/Index%20Scan%20in%20Descending%20Order 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 3 years ago
sqlcopter
284
5 Answers
2

USE_DESC_IDX applies to all index scans in the query.

link comment (0)
answered 3 years ago
ginarrbrik
516
tagged




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



Internet Explorer: Mozilla Firefox: Google Chrome: