i have a question regarding performance for loading data via script: In qlikview it is possible to embed tables and views of a SQL Server Sybase, SQL Anywhere (ODBC). If i execute a query in load script, which one is faster:
SELECT * FROM View or SELECT * FROM Table?
Is it advisable to merge more tables to one view and execute the view in the load script? We have a table with more than 1 milion data records and i have the creeping feeling that this would be very slow.