Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what are function we cad non optimized qvd?n use for optimized qvd an
Hi manojqlik,
from http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/
Some examples of things that will cause a non-optimised load are:
- Adding new fields to the table
- Deriving new values from a field in the QVD
- Retrieving a field twice
- Most WHERE conditions
- Joining to an existing in memory table
- Loading data into a mapping tableIn contrast the things you are allowed to do are:
- Rename fields
- Omit fields
- Do a simple one field WHERE EXISTS on a field returned in the record set
Hi, Manoj.
Have a look at Steve Dark's blog on optimization:
www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/
Cheers,
Neil
i want only the function names used in optimized qvd and non optimized qvd