How Does Automatic Caching Work with Row-Level Security in Oracle Analytics DV?
Oracle Analytics DV automatically caches the most frequently queried data to improve performance. However, if a dataset is sourced from a subject area with row-level security (RLS) applied, the query results can vary for each user.
Given that the dataset output differs based on user access, does the automatic caching mechanism still result in cache hits? Or does every user’s query create a unique cache entry, making caching ineffective?
Are there any best practices to optimize caching when RLS is involved?
Appreciate any insights from the community!