Search code examples
sqlsql-servercrystal-reports

sql server - are there any advantages to making a table out a view


I have a crystal report connected to a sql server DB that uses complex statistical queries. What are the disadvantages or advantages, especially in terms of speed, to converting views into tables to run in the reports. For sql server I know that tables take up more space.

thanks


Solution

  • Disadvantages:

    • occupies more spaces.
    • processing time for the table to load time.

    Advantages:

    • faster access