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: Slow cursor

Re: Slow cursor

From: <michael_bialik_at_my-deja.com>
Date: Tue, 23 Nov 1999 21:33:51 GMT
Message-ID: <81f17p$hon$1@nnrp1.deja.com>


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

Original text of this message

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