Re: Oracle Views and Indexes
From: Pete Kolton <peter.kolton_at_nspmbtinternet.com>
Date: Wed, 24 Nov 1999 09:05:30 -0000
Message-ID: <81g9kj$cne$1_at_supernews.com>
Date: Wed, 24 Nov 1999 09:05:30 -0000
Message-ID: <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 [Quoted] that you want. Much easier for you to see what's going on.
-- ======================================================== Pete Kolton ORACLE Systems Consultant All reasonable offers considered :-) Pete_at_kolton.com http://www.kolton.com ========================================================Received on Wed Nov 24 1999 - 10:05:30 CET