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

Thread: Question about table designing

  1. #1
    Join Date
    Apr 2003
    Posts
    26

    Question about table designing

    First of all , I'd apologize all friend for my delay to answer them about their responds , because some healthy conditions ..

    I'd thank all friends who have helped me (alapps , akhadar , bkiran , ggnanaraj , pando , stecal ) , and tell them that I can now startup two database on the same server at the same time , by setting up the oracle_sid system variable , and I'wanna evaluate all replies from .
    ****************************************

    And I'd like to ask another question , about :

    -We have a new Oracle project , includes a ( Personality ) Table , which will be a in the future a huge table , and we are discussing ( about tables like that , and the accounting tables which have a big count of rows ) about when we want to specify the data upon the year ( or another column like city or country , for more enhancement to the performance by decreasing the count of selected row in each coming query ) … let us say that we need to make the Personality table specified by year , we are thinking in three ways :

    First , on every end of every year , we have to build a new schema and execute the script of this table in it and let the user connect with a new accounting year , and when he wants to work with the data of last year ( or years ) , he has to choose ( connect with xxxx year ) option , and so on ..

    Second , I'm thinking in Partitioning this tables , with rang based on the year column …

    Or , staying with on huge table , working with sample views .

    So now , I wanna ask your opinions about which way we see it more practical to project will give to customers , and will hand over to users , will criticize by screaming any slow down status in work …

    Thanks Very Much …

    Tarek Al'Kaddoumi ...

  2. #2
    Join Date
    Mar 2002
    Posts
    534
    I would recomand you to range partition your table on a monthly base.

    I dont think that the 2 other options make any sense.

    HTH
    Mike

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