Has anyone had any experience, and if so, want to help me out and give me some refrences and such on how to do it? Thanks.

Sorry, my company only runs the Standard Edition of SQL2000. I believe indexed views (aka materialized views) are available in the Enterprise Edition only.

As always, BOL (Books Online) is the first place to start looking. Since I've never had the chance to use an indexed view I can't say much else. I think that the view resultset is stored in the database as though it were a base table.

I am working around a serious slowdown in our system with a similar approach (we use MS-Access as the frontend to the SQL Server...in spite of my lectures against this... ).

In short, a stored procedure writes a record to a base table I created specifically for holding the view results. Now the Access reports that are taking forever to print have direct access to the data. Once everything is printed, a second stored procedure truncates the table since I have no need to keep the data around any longer. I use truncate instead of delete because it is a non-logged operation.

HTH!