Re: Append without UNION

From: marcmc (marcmc_at_discussions.microsoft.com)
Date: 03/08/05 

Date: Tue, 8 Mar 2005 06:15:05 -0800

any other ideas how I can get all the rows and index my view without the use
of UNION/OUTER JOIN or any other rule breakers?

"Hugo Kornelis" wrote:

> On Tue, 8 Mar 2005 04:23:02 -0800, marcmc wrote:
>
> >Maybe its the full outer join in the design.
>
> Hi marcmc,
>
> Yes, that must be the reason. According to Books Online, outer joins are
> not permitted in an indexed view.
>
> Best, Hugo
> --
>
> (Remove _NO_ and _SPAM_ to get my e-mail address)
>

Quantcast