topic Re: Query Optimisation in QlikView https://community.qlik.com/t5/QlikView/Query-Optimisation/m-p/1173949#M910029 <HTML><HEAD></HEAD><BODY><P>1: The actual query will be performed as SQL (as in "your database") and the output will be send to QlikView.</P><P>2: For that we will need more information about the exact query you are trying to perform.</P></BODY></HTML> Sun, 12 Jun 2016 11:06:20 GMT oknotsen 2016-06-12T11:06:20Z Query Optimisation https://community.qlik.com/t5/QlikView/Query-Optimisation/m-p/1173948#M910027 <HTML><HEAD></HEAD><BODY><P>Hey hi fellows , I need help for query optimization . I have few tables , they form certain joins among themselves . </P><P>I am to convert sql script into qlikview script . Before starting this , i have few doubts in my mind </P><P></P><P>1. If i directly use sql script in select statement of qlikview , what impact it will give me </P><P> whether it will increase query execution time as sql itself is going to perform query execution and returning the resultant output to qlikview </P><P>2. If i&nbsp; pull related tables in qlikview and then perform all the operations in qlikview , is it work faster comparing to my previous point (Point No 1)?</P><P></P><P></P><P>Thanks in advance </P><P>Nitesh </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Query-Optimisation/m-p/1173948#M910027 2020-11-25T16:16:04Z Re: Query Optimisation https://community.qlik.com/t5/QlikView/Query-Optimisation/m-p/1173949#M910029 <HTML><HEAD></HEAD><BODY><P>1: The actual query will be performed as SQL (as in "your database") and the output will be send to QlikView.</P><P>2: For that we will need more information about the exact query you are trying to perform.</P></BODY></HTML> Sun, 12 Jun 2016 11:06:20 GMT https://community.qlik.com/t5/QlikView/Query-Optimisation/m-p/1173949#M910029 oknotsen 2016-06-12T11:06:20Z