Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index Range Scans....
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