It depends on your reason for partitioning -- if you mean to drop a partition in the future (to roll off the 1999 data or whatever) then the ID range is potentially a valid approach, as long as ID is serial. If you just want to put chunks on different disk volumes, you could use the type or even a hash partitioning scheme. It's down to what you're trying to accomplish, and what is good for one partition key is probably bad or neutral for the other.
Hamid Alavi wrote: > Hi List, > > I have a question regarding partitioning: If I want to partition a table > which strategy is better, like do i have to use a value which from first day > of using this table all those partion is using or just using first partion, > then second etc. > E.G: > If I do partion tableA based on ID range 10000000, so for few month the only > first partion of this table will be used then second partion, but if I > partion it on Type (1,2,3,4,5) any record can be any of these type and from > first day all of the partions will be used. > Just want to check with you guys which way is better for performance? > THanks for HELP> > > Hamid Alavi > Office 818 737-0526 > Cell 818 416-5095 > > ======================= Confidentiality Statement ======================= > The information contained in this message and any attachments is > intended only for the use of the individual or entity to which it is > addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL > and exempt from disclosure under applicable law. If you have received > this message in error, you are prohibited from copying, distributing, or > using the information. Please contact the sender immediately by return > e-mail and delete the original message from your system. > ===================== End Confidentiality Statement ===================== > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing).
begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard