Re: select on partition

From: JONL <jon.m.landenburger_at_verizon.com>
Date: 28 Sep 2005 11:27:35 -0700
Message-ID: <1127932055.596665.223110@g49g2000cwa.googlegroups.com>

Well Finally got around to setting the parms and had no effect.
>From with Benthic I

alter session set "_subquery_pruning_enabled" = true;
alter session set "_subquery_pruning_cost_factor" = 20;
alter session set "_subquery_pruning_reduction"=100;
SELECT count(*)
---    FROM     BILL_INVOICE_DETAIL partition (BID_DATA_P57)  "BID",
Bill_invoice BI
 FROM BILL_INVOICE_DETAIL BID,       BILL_INVOICE BI

WHERE to_char(BI.to_date, 'MON-YYYY') = 'JUN-2005' and BID.index_bill_ref = BI.index_bill_ref ;

The query had the same cose as without the alter statements. And of course if I query on the partion its a slim low cost query. Statistics were done at the beginning of the month. Received on Wed Sep 28 2005 - 13:27:35 CDT