dreamslogic (6/13/2009)
Hi Steve - Here are the choicesCreate a new View
Use a cursor and store the data in a temporary table
Create an Indexed View
Create a User Defined Function to return the needed data
Create a new Table
None of the above. Rewrite the query and/or view so that they are written optimally and add any necessary indexes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability