-1

How to use secondary index in select statement when database is DB6

Hi Experts,

I want to use secondary index in my select statement, I found the statement also but that statement is like - %_HINTS ORACLE 'INDEX("RSEG" "RSEG~AD")'.

But my database is DB6, so in this case shall i use like - %_HINTS DB6 'INDEX("RSEG" "RSEG~AD")'.

Please suggest.

Thanks,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 07, 2017 at 10:07 AM

    Read also reference note for your DB like 150037 - DB6: Database hints in Open SQL (or generic note 129385 - Database hints in Open SQL)

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 07, 2017 at 10:00 AM
    Add comment
    10|10000 characters needed characters exceeded

Skip to Content