Database Design Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Database Design

  1. #1
    Join Date
    Nov 2000


    Hi Friends,

    WE are having following software and hardware.
    Oracle 8i Release 2(8.1.6) and Operating System is Sun Solaries 2.8
    on Sun E6500 Machine.Database size will 3 terabytes.

    We are going to maintain inserts and select operation in this database. No update is going to occur. At presently I am planning to design one table and partiton ,subpartition and index on 16 different
    columns . We r able to maintain only three days of data , old data is truncated regulary , Database is in no archivelog mode.We r having backup at NIC side . Table's max record size is 360 bytes and 82 fields but around 32 fields are generally remain null.
    At presently I am planning for one table and partition ,subpartition and index it and trying to distribute data on EMC disks as i can .
    But I want to know one table will give a better performance or i should go for multiple tables,while one table is possible.
    Waiting for ur feedback.
    Thanks and have a great Day.

    db block size is 8k,
    table will be of 1 tb,
    we r having daywise range partition
    we r having 16 diffrent index and also partitioned

  2. #2
    Join Date
    Sep 2000
    I will go with multiple tables given this option...

  3. #3
    Join Date
    May 2000
    You do not need multiple tables. Single table is enough.
    Since you are going to have day wise partition, every day you can drop the 3 days old partition and add one new partition. This can be achived through a automated procedure or Shell Script.

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