Re: Performance of Views
From: PKelley772 <pkelley772_at_aol.com>
Date: 1996/04/08
Message-ID: <4ka5i7$jvm_at_newsbf02.news.aol.com>#1/1
Date: 1996/04/08
Message-ID: <4ka5i7$jvm_at_newsbf02.news.aol.com>#1/1
Roald van Geleuken suggested that views in general are slow. I'm not sure that I agree. I agree that it is quite easy to create slow views, but I have seen 7 or 8 table views that run very quickly - nearly instantaneous retrieval. Smallest table - about 6,000 rows; the other tables minimun 120,000 rows. About 20 rows generated by explain plan. The key seems to be to properly index the base tables and to tune the query to make use of the indices.
Views are a very heavily used tool at my shop and are not considered to be
inherently slow.
Paul Received on Mon Apr 08 1996 - 00:00:00 CEST