Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Views and performance

Views and performance

From: Jeff User <jeff31162_at_hotmail.com>
Date: Tue, 05 Sep 2006 22:47:03 -0400
Message-ID: <7kdsf25d8f7pi4ig87k8mcjaq4avb3b63j@4ax.com>


Hi everyone

I would like to know if using several views for a complicated query is slower than placing all the code in one large query.

I had heard that views were expensive in terms of performance, but I find them used quite a bit.

Jeff Received on Tue Sep 05 2006 - 21:47:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US