Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Slow cursor
Hi.
Are you sure you don't have additional conditions in WHERE clause? It looks like you supposed to see FULL table access to either tabA or tabB.
Michael.
In article <383ac111.23589830_at_news.space.net>,
jmayer_at_ratundtat.com wrote:
> Hi there,
>
> we have a problem with the performance of a cursor. The cursor is a
> join of two tables A and B, A has about 500.000 records, B about
> 10.000.000 records. Primary key of A is col1, primary key of B is
> col1,col2. The join is like
>
> select ...
> from a,b
> where a.col1 = b.col1
>
> The execution plan uses a unique index access for table A and a index
> range scan for table B
>
> We're using this cursor in a package, where it needs 4 seconds to
> retrieve about 10 records. In my opinion, this is SLOW! If we test the
> same select-statement directly from the SQL*Plus-Prompt, the DB
> answers in less than 1 seconds.
>
> How can we tune this ? The cursor has to be executed several thousand
> times, this will last for hours....
>
> Can anyone help ?
>
> Jens
>
> -
> Jens Mayer
> Rat & Tat GmbH
> Hamburg, Germany
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Nov 23 1999 - 15:33:51 CST