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

Thread: Partition method?

  1. #1
    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    What do you hope to acomplish by partitioning?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Oct 2002
    Posts
    21
    faster access of the table
    We frequently (many times daily) query table X by the Column A .

  4. #4
    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?

  5. #5
    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

  6. #6
    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

Posting Permissions

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


Click Here to Expand Forum to Full Width