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

RE: partitioned tables and the optimizer's behaviour

BDY.RTF Description: RTF file