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: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.com>
Date: Sat, 01 Feb 2003 21:17:06 GMT
Message-ID: <mPW_9.122104$6G4.14443@sccrnsc02>


Can you post the definition of the view? Jim
"Nicolas Bronke" <bronke_at_gmx.de> wrote in message news:b1hcc3$12p0ut$1_at_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 - 15:17:06 CST

Original text of this message

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