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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 25 Feb 2006 18:07:03 +0100
Message-ID: <1j3102pjsoech1ttp9fk20vdq72suitmcl@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


Received on Sat Feb 25 2006 - 11:07:03 CST












Original text of this message













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