OBIEE - Query Plan

About

The query plan in OBIEE

Articles Related

Cache

To disable the query cache plan:

• For on query or session, you can set the following system session variable to 1

DISABLE_PLAN_CACHE_HIT=1

• For the whole system, set the MAX_QUERY_PLAN_CACHE_ENTRIES to zero in the nqsconfig.ini

MAX_QUERY_PLAN_CACHE_ENTRIES=0