HI ,
When i specify count(1) from partition
say
select count(1) from acct_stmt PARTITION (OCT2000)
/
it uses the full table scan of the table and not the partition alone .

Does the aggregate functions use the full table scan inspite of the partitions

Regards
Shyla