topic Cached Query Execution Plan Using DBO. in QlikView https://community.qlik.com/t5/QlikView/Cached-Query-Execution-Plan-Using-DBO/m-p/413554#M699822 <HTML><HEAD></HEAD><BODY><P>I have been looking around the community and in various reference tools and have not found a direct answer to this question.&nbsp; </P><P></P><P>I am cleaning up and optimizing some older reports and am new to QlickView, so I am not 100% sure on how the query gets passed by QV.</P><P>In Crystal Reports, I can press the SQL Query button and it gives me the query it will use on the server; but I cannot find the same animal in QV.</P><P></P><P>Does QV pass the query directly to the server without any re-translation? </P><P>Does the TSQL practice of using dbo.tablename with the dbo. schema prefix increase any server performance by cacheing execution plans?&nbsp; </P></BODY></HTML> Thu, 06 Dec 2012 15:10:58 GMT 2012-12-06T15:10:58Z Cached Query Execution Plan Using DBO. https://community.qlik.com/t5/QlikView/Cached-Query-Execution-Plan-Using-DBO/m-p/413554#M699822 <HTML><HEAD></HEAD><BODY><P>I have been looking around the community and in various reference tools and have not found a direct answer to this question.&nbsp; </P><P></P><P>I am cleaning up and optimizing some older reports and am new to QlickView, so I am not 100% sure on how the query gets passed by QV.</P><P>In Crystal Reports, I can press the SQL Query button and it gives me the query it will use on the server; but I cannot find the same animal in QV.</P><P></P><P>Does QV pass the query directly to the server without any re-translation? </P><P>Does the TSQL practice of using dbo.tablename with the dbo. schema prefix increase any server performance by cacheing execution plans?&nbsp; </P></BODY></HTML> Thu, 06 Dec 2012 15:10:58 GMT https://community.qlik.com/t5/QlikView/Cached-Query-Execution-Plan-Using-DBO/m-p/413554#M699822 2012-12-06T15:10:58Z