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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Performance Problem with View

Re: Performance Problem with View

From: Nicolas Bronke <bronke_at_gmx.de>
Date: Sat, 1 Feb 2003 21:57:39 +0100
Message-ID: <b1hcc3$12p0ut$1@ID-121870.news.dfncis.de> 





> What version?  What is the explain plan and the tkprof output?  What is

the


> view? What indexes exist?  Have the tables and indexes been analyzed?

Sorry forgot Oracle 8.1.7 on Win2000.


On my joined tables there are existing the required primary key.
With the foreign view, I have to find it out by the 3rd party developer.



Explain Plan -> I tried that with Toad, but I got an error. Analyzed I think
not.



Regards Nicolas
Received on Sat Feb 01 2003 - 14:57:39 CST












Original text of this message













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