Re: Many Schemas

From: Galen Boyer <galenboyer_at_yahoo.com>
Date: 7 May 2001 16:13:10 -0500
Message-ID: <uitjcrhgp.fsf@primix.com>

On Mon, 07 May 2001,
SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK wrote:
> My understanding is, that queries done on views cannot be fully
> optimized. Thus any complex queries would need to be done on
> the one schema, which defeats the entire purpose. Am I correct?

Views on views can cause issues because then it is very difficult to influence what happens after view resolution, but a view as a straight join should be able to be tuned.

-- 
Galen
I don't want to be the rock.  Yeah, okay, what do you want to be?
I want to be the piece of glass.

Received on Mon May 07 2001 - 16:13:10 CDT