Dear DBAndrey,
use :
A.> assuming start_date to be of dd/mm/yyyy
select trunc(ADAY,'DD') , count(...),sum(...),...
from THETABLE
where trunc(ADAY) >= :start_date /* changes done here add TRUNC function
to ADAY */
group by trunc(ADAY,'DD')
B.> assuming start_date to be of dd/mm/yyyy hh24:mi
select trunc(ADAY,'DD') , count(...),sum(...),...
from THETABLE
where nvl(ADAY,to_date('01/01/1800 00:00','dd/mm/yyyy hh24:mi') >=
:start_date /* changes done here add NVL function to ADAY */
group by trunc(ADAY,'DD')
regards,
Ams.
www.medicomsoft.com
-----Original Message-----
Sent: Monday, July 15, 2002 1:53 PM
To: Multiple recipients of list ORACLE-L
Dear list !
i have a table , which is partitioned by a date column (let's call it ADAY)
Each day is a separate partition.
I have this sort of a query :
select trunc(ADAY,'DD') , count(...),sum(...),...
from THETABLE
where ADAY >= :start_date
group by trunc(ADAY,'DD')
I.e. i want to perform some calculations for the last couple of days
(governed by the :start_date - passed as a parameter, not fixed).
Now , i want to force the query to perform the Full scan (not an index scan)
only of the required partitions (i.e. for the required days).
How can i do that , please ?
TIA
DBAndrey
* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrey Bronfin
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Amjad
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
