Re: Choice of Partition on a BIG INT
Hello Phil and thanks for your reply.
It turns out that I will be able to use RANGE partitions for the first set of bits that I want to partition by.
The last couple of bits that I wanted to use will be 4 bits based on the year. I'm going to manually implement subpartitions where I need to.
I envisage that most of my queries won't be using bitwise operators and more likely ranges/IN (a,b,c) values.
Thanks...
Subject
Views
Written By
Posted
4063
October 15, 2008 02:26AM
2675
October 15, 2008 10:36AM
Re: Choice of Partition on a BIG INT
2657
October 22, 2008 10:46AM
2253
January 21, 2009 11:10AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.