Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Performance Problem with View
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
![]() |
![]() |