Results 1 to 3 of 3

Thread: Partitioning the table to store the archived projects

Threaded View

  1. 06-02-2003, 04:25 AM #1
    Lavr
    Lavr is offline Registered User
    Join Date
    Jun 2003
    Posts
    7

    Partitioning the table to store the archived projects

    Hello, I am developing the database for one project-management system.
    All projects are stored in the table PROJECTS. There can be thousands of projects.
    Now I must enable the possibility to make the projects "archived". Such projects are no more visible and changeable.
    Is it a good idea to add one field "ARCHIVED" and then split the table in two partitions (ARCHIVED = 0 and ARCHIVED = 1)?
    I hope I can get better preformance with such partitioning.
    Am I right?
    Last edited by Lavr; 06-02-2003 at 06:27 AM.
    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