Hello all,.
I have a query which when executed seems to use the materialized views.. The query has multiple plans but the one without the use of Materialized view is the fastest.
My question : How to disable the use of MV's while a query is being executed ? In other words, I want the optimizer to use the base tables and not the MV's associated with them
Thanks in advance