Posted by MC on 05/06/07 06:15

You're right offcourse. Union is not allowed in indexed view. So, either
redesign or programmatical checking...


MC


"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:lf6%h.222$4X.95@nlpi069.nbdc.sbc.com...
>I believe UNION is one of the disallowed constructs of an indexed view.
>However, I agree that the need to do this is probably a schema design
>issue.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "MC" <marko.NOSPAMculo@gmail.com> wrote in message
> news:f1ijhg$c13$1@ss408.t-com.hr...
>> You mean spaning two tables? No, not as such. You could try creating an
>> indexed view, but that will hurt performance. Anyway, perhaps supertype
>> is in order (depending on the enitites)?
>>
>> MC
>>
>>
>> "Igor" <jerosimic@gmail.com> wrote in message
>> news:1178387342.966780.319330@q75g2000hsh.googlegroups.com...
>>> Is it possible to create a unique constraint on two tables?
>>> In mssql2000?
>>>
>>
>>
>

[Back to original message]