Re: Views, general question
From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/07/03
Message-ID: <39607087.6FC7_at_yahoo.com>#1/1
Date: 2000/07/03
Message-ID: <39607087.6FC7_at_yahoo.com>#1/1
Greg wrote:
>
> Should I create on View with all needed Data included
> or is it better to make several views.
>
> Maintenance is easier whit "one does it all"
> how about performance ??
>
> thanks greg
Really depends on the view - one of the Oracle manuals ("Tuning" I think) talks about view integration versus view resolution as well as some new features in 8.0 & above in pushing where clauses into the view at runtime etc.
HTH
-- =========================================== Connor McDonald http://www.oracledba.co.uk We are born naked, wet and hungry...then things get worseReceived on Mon Jul 03 2000 - 00:00:00 CEST