Opinion on Views

From: David Fenton <dfenton_at_geopower.com>
Date: Tue, 26 May 1998 16:27:48 -0400
Message-ID: <356B25C4.BDB3BD54@geopower.com>

I'm looking for people's opinion on views. How efficient are they compared to joins for instance. When designing a report is it better to create a view to join two tables and use that view in the report or directly do the join in reports? When should views be used? For security

purposes? Is the view faster than doing the query directly?

I'm trying to get a popular opinion so any info would be helpful

Thanks

David Received on Tue May 26 1998 - 15:27:48 CDT