topic Re: SQL Server: view or table for query? in QlikView

SQL Server: view or table for query?

Mon, 26 Jan 2026 18:19:17 GMT

Hey experts,

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.

Thanks in advance and regards from germany

Sabrina

Re: SQL Server: view or table for query?

Anonymous — Tue, 05 May 2015 08:01:43 GMT

First of all, select * is not preferable for either data from table or view..; unless all columns are required for design; it is unnecessary data with increasing weight of app or QVD.

In view, generally columns from tables which are necessary will be considered and data reduction will be already done with required sql query. So, it will be optimum to load from views than tables.

Re: SQL Server: view or table for query?

Tue, 05 May 2015 08:32:45 GMT

Select * was only an example 😉

Thanks for your answer.

So we will make views over the needed tables and load these views via load script.

Regards

Sabrina