Hey I currently do not have stats loaded and have a composite partition table corralated with a legacy table. I am wondering if I can force the CBO to use a specific partitions index and hash via a hint.
Is this possible? (partitioned by calldate and hashed by customerinfoId)
Many Thanks,
-Lizz
Here is my sql:
select * from customerinfo
where calldate between
TO_DATE('2003-05-21 00:00:00','YYYY-MM-DD HH24:MI:SS')+ 10/24
and TO_DATE('2003-05-22 00:00:00','YYYY-MM-DD HH24:MI:SS')+ 10/24
and Spare7 = '20'
and verified = 'Y'
and account_no ='864239913' and call_id <> '0'
or call_id in (
select call_id from voicelog.audit_table
WHERE audit_table.event_type = 3
and event_id between
TO_DATE('2003-05-21 00:00:00','YYYY-MM-DD HH24:MI:SS')+ 10/24
and TO_DATE('2003-05-22 00:00:00','YYYY-MM-DD HH24:MI:SS')+ 10/24
and call_id in (
&! nbsp; select call_id from customerinfo
where calldate between TO_DATE('2003-05-21 00:00:00','YYYY-MM-
H24:MI:SS')
and TO_DATE('2003-05-22 00:00:00','YYYY-MM-DD HH24:MI:SS')
and Spare7 = '20'
and verified = 'Y' and account_no ='864239913'
and call_id <> '0'
)
)
/
where calldate between
TO_DATE('2003-05-21 00:00:00','YYYY-MM-DD HH24:MI:SS')+ 10/24
and TO_DATE('2003-05-22 00:00:00','YYYY-MM-DD HH24:MI:SS')+ 10/24
and Spare7 = '20'
and verified = 'Y'
and account_no ='864239913' and call_id <> '0'
or call_id in (
select call_id from voicelog.audit_table
WHERE audit_table.event_type = 3
and event_id between
TO_DATE('2003-05-21 00:00:00','YYYY-MM-DD HH24:MI:SS')+ 10/24
and TO_DATE('2003-05-22 00:00:00','YYYY-MM-DD HH24:MI:SS')+ 10/24
and call_id in (
&! nbsp; select call_id from customerinfo
where calldate between TO_DATE('2003-05-21 00:00:00','YYYY-MM-
H24:MI:SS')
and TO_DATE('2003-05-22 00:00:00','YYYY-MM-DD HH24:MI:SS')
and Spare7 = '20'
and verified = 'Y' and account_no ='864239913'
and call_id <> '0'
)
)
/
Do you Yahoo!?
Free online calendar with sync to Outlook(TM).
