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

Home -> Community -> Usenet -> c.d.o.server -> Re: View performance tuning

Re: View performance tuning

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sun, 26 Feb 2006 07:04:17 -0500
Message-ID: <o4SdnXSkLYrfBJzZRVn-rg@comcast.com>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:1j3102pjsoech1ttp9fk20vdq72suitmcl_at_4ax.com...
: On Sat, 25 Feb 2006 17:37:57 +0100, Geld Marcoss <geld1_at_nexus.hu>
: wrote:
:
: >How can I improve the speed of the view?
:
: 1 make sure you understand what a foreign key is
: 2 put appropiate foreign key constraints on your tables
: 3 index the foreign key columns
: 4 make sure statistics on the tables are current
: 5 remove the outer join.
:
: --
: Sybrand Bakker, Senior Oracle DBA

#1-4 yes
#5 -- no

++ mcs Received on Sun Feb 26 2006 - 06:04:17 CST

Original text of this message

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