Re: Views

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Tue, 09 Dec 2003 21:37:18 +0100
Message-ID: <ahcctvok8ivje90th47ogrohfnh1771s98@4ax.com>

On Tue, 09 Dec 2003 20:25:52 GMT, "Roger Smith" <rsmith22_at_fastmail.net> wrote:

>Hi,
>
>Is creating a view that uses another view bad practice?
>
>Roger
>

If you don't like spaghetti code and/or gordian knots : yes

Other than that, it depends.
You might however run into the situation your views are executed as separate steps by the optimizer, which isn't necessarily good

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Dec 09 2003 - 14:37:18 CST