Quick question -- sql server clients

Joh
5/27/2005 12:00:00 AM

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.

John Bell
5/29/2005 12:00:00 AM

Hi

Have you read through
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_06_17zr.asp
to make sure that you have met all the correct criteria?

John

[quoted text, click to view]

sql server clients : Quick question