The application is a cross-reference piece that cross-references symbols from different data providers (symbolsetIDs).  In the end it's used to display stock market information / research to web clients.

The idea is...

The table in question contains a list of Symbols that are associated to SymbolSetIDs.

I need to be able to lookup data from this (and other joined tables), based on...

Indexed view idea is to speed up performance.

The task is extremely complex.  Do you seriously want me to post a novel on what this nasty query is trying to accomplish?

Derived tables also not allowed in Indexed Views.  That's yet another restriction of these oh-so-helpful-pain-in-the-ass-indexed-views.

http://support.microsoft.com/?kbid=899761

Could you post the text of the proc ?

Thanks, I've already seen that.  I was hoping to get feedback from someone who actually uses it in a production environment.  But thanks for teaching me how to use google...

Lookup "Backup Log" in Books Online and you should be able to figure it out from there.

Have you thought about having a single stored procedure that returns all the data needed for this page?  Reducing round trips is usually a decent way of imrpvoing performance.  Also,...

checkpoint

Try this:

select terms.key,

CASE

when  plan.desc like 'Lendered%'  then terms.amt as "Broked"

when plan.desc  then terms.amt

end as plandesc 

from terms, plan

where terms.key = plan.key and desc like 'Lendered%'

rather than:

select terms.key,

CASE plan.desc

when ...

I had to re-order the columns in the clustered index on the view, and that seemed to fix my execution plan(s).

Disregard this post, I managed to figure it out.

1.5 MB is not a "big growth" for most SQL databases.  Did you mean to say 1.5 Gig?