Re: Oracle Views and Indexes
From: Justin Wigg <justinwigg_at_yahoo.com>
Date: Fri, 26 Nov 1999 15:21:21 +1000
Message-ID: <383e0ac6_at_derwent.nt.tas.gov.au>
Date: Fri, 26 Nov 1999 15:21:21 +1000
Message-ID: <383e0ac6_at_derwent.nt.tas.gov.au>
Pete Kolton <peter.kolton_at_nspmbtinternet.com> wrote in message
news:81g9kj$cne$1_at_supernews.com...
> >me - honest!) I realised that it a fourth generation view. ie., this
view
> >is based on another view which itself is based on two different views
which
> >in turn each select from a combination of views and tables.
>
> Personally, I'd go with a new view that just selects directly on the
tables
> that you want. Much easier for you to see what's going on.
Many thanks to all for your help.
--
Dogs believe they are human. | Justin Wigg - Hobart, AUSTRALIA
Cats believe they are God. | Reply to: justinwigg_at_yahoo.com
- Unknown | http://www.geocities.com/~justinwigg
Received on Fri Nov 26 1999 - 06:21:21 CET