>>http://www.hlstechnologies.com/downloads/IDUGDallas.pdf >I found the PDF via Google search and am looking into it.
This was surely of great help to me! Let me see if I understand what my problem is: o The SQL in question does *not* specify correlation names o BIND with EXPLAIN inserts rows into the PLAN_TABLE o Since no correlation name was used, the corresponding PLAN_TABLE column is NULL o BIND with OPTHINT compares correlation name from SQL (i.e. "blank") with content of correlation_name column (i.e. NULL) to see if the hint is for "this program" NULL is not equal to "blank", so then hint is not used. If I change the correlation_name column in the PLAN_TABLE to "blank", then the hint would be accepted. -- Peter Hunkeler ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
