Posted by Erland Sommarskog on 02/05/07 14:58

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@sommarskog.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

[Back to original message]