Re: Partition by three column values

Deepak, Sandeep,



As Sandeep had mentioned, all the queries will
definitely have acct_id. But he didn't mention whether
cr_date will also 'always' be there.



my point was very simple. By the decision about the partitioning I would additionally consider the following:




if the time dimension (cr_date) consists of a large number of distinct values (e.g. timestamps) it is better to assign it as a range partition key.



if some dimension is used alternatively with BETWEEN predicates it is better to assign it as a range partition key. A between predicate could be quit common for time dimension.



But yes of course in special case if the time dimension has a fixed granularity (e.g. monthly) and you get one new account per month on average, there is no really a big difference between those two dimensions.



Regards,



Jaromir





----- Original Message ----- From: "Deepak Sharma" <sharmakdeep_oracle@xxxxxxxxx>
To: <jaromir@xxxxxxxxxxxx>; <dubey.sandeep@xxxxxxxxx>
Cc: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, February 23, 2006 5:09 AM
Subject: Re: Partition by three column values



-- http://www.freelists.org/webpage/oracle-l


Other related posts: