This content has been marked as final. Show 2 replies
What output do you want to see?
ODCITABLEREWRITE is executed at compile time, so there will be no output in the trace files. But if you can explain what you want to see we can see if we can get to that information any other way.
I would like to the entire SQL statement being executed so I can optimize it by creating additional indexes, Materialized Views on RDF_LINK$ (sub-sub, sub-obj, ..etc.) as explained in one of your papers. I am not getting good performance and the explain plan of the SEM_MATCH does not look like optimized.
Your help is appreciated.