• Indexed views could help.

    If you create the table, which is just a matter of creating the table using the CREATE TABLE T-SQL syntax, you will then have to load and maintain the data in that table. Be sure that's the right way to go. Also, before you go down this road, be sure you've tuned the query performance as much as you can. Maybe there are other tuning opportunities in the query.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning