use of union in indexed views

[Mr,Goody]

hi frends.
i have such a great problem.i want to use union in indexed
view and i must have to use it. because i cant make a one table
because in those two tables there are 2,000,000 records entered
daily.So please give me suggestion. can also give me alternate of
using UNION in indexed view.and i want to use idexed view only because
i will do searching afterwards.

Regards,
Mr.Mirza
Software Engineer.

[Erland Sommarskog]

Re: use of union in indexed views

Mr,Goody (qualified.boys @gmail.com) writes:

i have such a great problem.i want to use union in indexed
view and i must have to use it. because i cant make a one table
because in those two tables there are 2,000,000 records entered
daily.So please give me suggestion. can also give me alternate of
using UNION in indexed view.and i want to use idexed view only because
i will do searching afterwards.

If you can't use a single table because of the volume, how would you be
able to use an indexed view? Adding an indexed view on the two tables,
effectively means that the rows need to be added twice.

Maybe what you really need is a partiontioned view? Or, if you have SQL 2005
Enterprise Edition, a partitioned table?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx