Hi all,
I'm not sure if this is an exclusive WCC aspect, but I would like to find how to control the hints generation in an SQL. I have a query identified by a name in custom_query.htm file. This query is called from Java code like
getWorkspace().createResultSet("myQuery", params);
so, pretty standard.
Thing is in the tracing I can see something like this added after the select word:
/*+ USE_NL (r baw wd w dm) LEADING(r)INDEX (r PK_Revisions)*/
How can I change what's generated so that to have another table as the LEADING ?
Is this something one can configure from WCC or is it something configurable on the DB...?
Thanks,
V.