Views that append data usually performs well. When it comes to joining it's a different story. On the other hand, a new table can be optimised by storing it on the most used dort order and applying indexes to it. If the data is static you could even remove the original tables if storage is a concern.
... View more