Home » Developer & Programmer » Designer » Table sizing
Table sizing [message #90459] Tue, 14 October 2003 11:20
Sankar
Messages: 10
Registered: February 2002
Junior Member
I have a history table which should hold 13months worth of data all the time. This gets inserted once in a month, and usually no updates. There are some reports run once in a month just on the previous month data.

I calculated the avg.length of record to be 270 and the no of records per day is 2000.

Under normal circumstances, what will be the storage criteria for the table ?

Report message to a moderator

Previous Topic: Constraints /Triggers
Next Topic: tablespace filled !
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Mar 25 05:51:22 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.