Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    55

    Unanswered: partitioning a database

    hi all,
    before i had a big database more than 90GB and it's growing very sharp so what i did is to create a summary database that gonna hold some aggregation and i create also three tables that gonna hold the data, on will hold the data for the last three months (very detailed information) one between 3 months and a year(less detailed) and the last one older than a year(less less detailed) these are the company requirement i'm working with.
    then i transfer the data to the new tables with stored procedures.
    now my question is: do i need to create a view for these three tables? and if yes how should i do it?!! cus i do not have the same columns in the three tables.
    thanks experts.
    Peace out
    Mr joka

  2. #2
    Join Date
    Oct 2006
    Posts
    55

    maintaining stored procedures

    hi all,
    i just posted another question .
    titeled optimizing stored procedure
    thanks
    Peace out
    Mr joka

Posting Permissions

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