Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is the best option for query between two:
1) To make query with joins at data base level and execute directly in QlikView..?
2) Select all data fields from data base and perform joins at QlikView level..?
Please discuss...
Well it depends on what you are trying to do. If the result of the joined query is much smaller than the underlying tables, it may make sense to do the join in the server to reduce reload time and bandwidth.
However, if this join is complex or coming from large underlying tables, then this might place an unacceptable burden on the server, and if it is a busy transaction processing server, you may want to prioritize the server availability over reload performance.
Hi,
This is a design decision which depends on solving task.
Best regards,
Maxim
Hi
It depends upon requirement and data