Query Cache

Question: We would like to create a few queries to test the reponse time of the system. These queries will run three times a day. I would like to run just these queries not using cache. Is there a way to turn off cache by query?

Steve

Answer:
Steve,

In RSRT query properties select Cache mode as inactive. This will be applicable for that query run by all users. I would suggest you to run it in RSRT with debug mode and select Donot use cache, if you are interested to analyze the query performance.

Hope this helps

Thanks
Copyright ?2007 - 2008 www.jt77.com