[sqr-users] Dynamically Use Oracle Hint

["Turner, Ivan" <Ivan.Turner@qwest.com>]

        I usually know the hint I want to use and write the code as such:

        Begin-Select on-error = mucked-up
        /*+ index(ia PSBITEM_ACTIVITY) */
        C.segment_id
        ia.business_unit
        o
        o
        o
        from ps_item_activity ia, pc_customer c
        where ...
        End-Select

        I now need to know if there is a way to build hints dynamically.  I 
will be accessing the table based on user choices where each choice has an 
index that is optimal for table access.  

        Has anyone done this?


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users