DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Partition method?

  1. 12-02-2002, 03:50 PM #1
    cora
    cora is offline Junior Member
    Join Date
    Oct 2002
    Posts
    21

    Partition method?

    Table X : 25mil records
    Column A: Varchar2 (6) has 3 distinct values ‘100’,’200’,’300’
    I want to partition table X but I am not sure what partition method to chose.

    Please advise

    thanks
    Reply With Quote Reply With Quote
  2. 12-02-2002, 04:08 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    What do you hope to acomplish by partitioning?
    Jeff Hunter
    Reply With Quote Reply With Quote
  3. 12-02-2002, 04:33 PM #3
    cora
    cora is offline Junior Member
    Join Date
    Oct 2002
    Posts
    21
    faster access of the table
    We frequently (many times daily) query table X by the Column A .
    Reply With Quote Reply With Quote
  4. 12-02-2002, 05:47 PM #4
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Don't you think specifying your database release would have anything to do with the available partitioning method?

    Pre 8.0: no method available
    8.0: 1 method available
    8i: 3 methods available
    9i: 4 methods available
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
  5. 12-02-2002, 07:28 PM #5
    grjohnson's Avatar
    grjohnson
    grjohnson is offline Senior Advisor
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    In your case either Range or List partitioning. Hash isn't helpful for partition pruning.
    OCP 8i, 9i DBA
    Brisbane Australia
    Reply With Quote Reply With Quote
  6. 12-02-2002, 08:46 PM #6
    eyen
    eyen is offline Member
    Join Date
    Jun 2000
    Posts
    117

    Cool Here is a short presentation on different partitioning methods in 9i R2

    http://www.nocoug.org/presentations.html

    Look for Oracle 9.2.0 Partitioning by Eric Yen
    E. Yen
    OCP DBA 8, 8i, 9i
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width