In the Query Properties dialog box in the query monitor, you can change the standard cache mode setting for existing queries.
Context
Procedure
To be able to change the cache mode, first remove the flag for the InfoProvider Setting option.
Make the required settings for the query in question.
Cache validity - the length of time that data is stored in the cache. You normally only set this per InfoProvider in Customizing. For InfoProviders whose data cannot be changed in the Business Warehous (such as VirtualProviders and DataStore objects for direct update), you can also specify the cache validity in the query monitor.
Next Steps
If you use the cache mode, meaning that you have not selected cache mode I: Cache is inactive, you can further optimize query performance by setting a cache usage mode.