Query Optimisation

[#1]

Hey hi fellows , I need help for query optimization . I have few tables , they form certain joins among themselves .

I am to convert sql script into qlikview script . Before starting this , i have few doubts in my mind

1. If i directly use sql script in select statement of qlikview , what impact it will give me

whether it will increase query execution time as sql itself is going to perform query execution and returning the resultant output to qlikview

2. If i  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)?

Thanks in advance

Nitesh

[oknotsen]

1: The actual query will be performed as SQL (as in "your database") and the output will be send to QlikView.

2: For that we will need more information about the exact query you are trying to perform.