|
|
Posted by Dan Guzman on 05/05/07 21:00
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?
>>
>
>
Navigation:
[Reply to this message]
|