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

Home -> Community -> Usenet -> c.d.o.server -> Re: Index Range Scans....

Re: Index Range Scans....

From: Miggins <mtproc_at_yahoo.co.uk>
Date: 3 Mar 2006 08:38:53 -0800
Message-ID: <1141403933.447534.247520@i39g2000cwa.googlegroups.com>


Gents am running 9.2 on windows. The statement is defined as a cursor in a packaged procedure and the 2 bind variables are taken from variables stored elsewhere in the program.

Mailing Runs table has around 10,400,00 rows the Mailing Run Details table has slightly less.

Mailing run details PK consists of

mrd_mailing_log_id
mrd_mld_item_seq
mrd_mru_item_seq

select	mr.mru_person_id,
	mr.mru_org_type,
	mr.mru_org_code,
	mrd.mrd_jsu_item_seq
from          mailing_runs mr,
	mailing_run_details mrd
where       mr.mru_mailing_log_id 	= :BIND1
and	mrd.mrd_mailing_log_id 	= mr.mru_mailing_log_id
and	mrd.mrd_mld_item_seq 	= :BIND2
and	mrd.mrd_mru_item_seq 	= mr.mru_item_seq

Query is taking about 20 mins to run and getting slower and slower as the tables grow. Received on Fri Mar 03 2006 - 10:38:53 CST

Original text of this message

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