Forum Discussion
Sound advice on improving Query Refresh
Correct and hopefully it will be part of your long-term solution otherwise the refresh will take as long as the initial load.
Other things to consider : query folding,
auto date/time settings,
not returning fields from the db that are not required,
using table.buffer if the same table is being loaded repeatedly in query transformations,
what's going on in the db when the load is being run, and so on
Correct and hopefully it will be part of your long-term solution otherwise the refresh will take as long as the initial load.
Other things to consider : query folding,
auto date/time settings,
not returning fields from the db that are not required,
using table.buffer if the same table is being loaded repeatedly in query transformations,
what's going on in the db when the load is being run, and so on