partitioned tables and the optimizer's behaviour

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:andreyb_at_elrontelesoft.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrey Bronfin
  INET: andreyb_at_elrontelesoft.com

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: ListGuru_at_fatcity.com (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).