Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: View performance tuning
"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