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?