Received: from smtp.snet.net (smtp.snet.net [204.60.6.55]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f66HWUa85125 for ; Fri, 6 Jul 2001 13:32:30 -0400 (EDT) (envelope-from wweng@kencast.com) Received: from pop.snet.net (pop.snet.net [204.60.6.9]) by smtp.snet.net (8.11.1/8.11.1/SNET-mx-1.4/D-1.10/O-1.7) with ESMTP id f66HWRC22554 for ; Fri, 6 Jul 2001 13:32:27 -0400 (EDT) Received: from [192.168.1.83] (167.95.252.64.snet.net [64.252.95.167]) by pop.snet.net (8.11.1/8.11.1/SNET-pop-1.5/D-1.8/O-1.6) with ESMTP id f66HWRr14142 for ; Fri, 6 Jul 2001 13:32:27 -0400 (EDT) Subject: view and performance From: Wei Weng To: pgsql-sql@postgresql.org Content-Type: text/plain X-Mailer: Evolution/0.10 (Preview Release) Date: 06 Jul 2001 14:38:17 -0400 Message-Id: <994444708.16303.3.camel@Monet> Mime-Version: 1.0 X-Archive-Number: 200107/73 X-Sequence-Number: 3857 Is there any gain on performance if you choose to create a view over a very complex query instead of running the query itself directly? Thanks! -- Wei Weng Network Software Engineer KenCast Inc.