Quick question

One quick question...I have a MedicalCause table and it contains 12
billions of records and I wanna do partitioning that table and wanna create
view as well as index on that view but the problem is the that SQL server
doesn't allow to create an index on view which contain "union" and I have to
go for partitioning then obviously I will use Union all query... any idea
what I have to do to fulfuil to create view as well as index over it.
Hi
Have you read through
http://msdn.microsoft.com/library/de...es_06_17zr.asp
to make sure that you have met all the correct criteria?
John
"Joh" <joh@.mailcity.com> wrote in message
news:O8C8IitYFHA.2288@.TK2MSFTNGP14.phx.gbl...
> One quick question...I have a MedicalCause table and it contains 12
> billions of records and I wanna do partitioning that table and wanna
> create
> view as well as index on that view but the problem is the that SQL server
> doesn't allow to create an index on view which contain "union" and I have
> to
> go for partitioning then obviously I will use Union all query... any idea
> what I have to do to fulfuil to create view as well as index over it.
>