• Since the description you give is on a fairly high-level, it is difficult to give exact advice, but, no, from what you say I don't think indexed views is what you need.

    To say more, we would need to see the tables (or preferrably some simplified layout of them) and how they are related. It sounds a little funny that you would search 10 entirely unrelated tables, so I assume that there is some form of relation between them.

    What I can say is that indexing common search terms helps a log.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]