Daily partitioning

From: Stefano Cislaghi <s.cislaghi_at_gmail.com>
Date: Fri, 14 May 2010 12:05:10 +0200
Message-ID: <AANLkTinRsn9xi75uNvRq5zw2L2tu1ZkpQiE8eMhEoP9L_at_mail.gmail.com>

Hi all,

just a question to discuss. I've a table want to be partitioned. Partition key should be a date field.
This table will retain data for last 40 days from sysdate, i.e. delete * from mytable where date < sysdate-40

Managing a partition for each day is too big ... 31 partitions. There's a way with virtual column reference the day of week and creating 7 partition...
Hash partition maybe useful ... but

... but how optimizer will use efficiently a partition based on virtual column for day of week when the query reference only the full date field? and also..how will use using hash partitions?

Any suggestion will be appreciated





http://www.freelists.org/webpage/oracle-l Received on Fri May 14 2010 - 05:05:10 CDT

Original text of this message