| http://www.w3.org/ns/prov#value | - has only 10000 records but there is a drastic degradation in the performance.Based on some recomondations I have used the materialized hint with the with clause and I could see that my query is performing well with 3 seconds.Can some please explain what does this Materialize hint does.
|
