2 Replies Latest reply: May 5, 2015 4:32 AM by Sabrina Oberdörfer RSS

    SQL Server: view or table for query?

      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