I understand that when using Direct Query, a user makes a selection and the script defined as Direct Query is executed agains the source database. The result set of that query is then returned to the user in the QlikView interface.
My question is;
When the result set is returned, is it loaded in to RAM? Does the RAM usage on the server increase with the result of the returned set?
Getting access to test this at my company will be difficult so any help from here would be much appreciated.