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 ?
Previous Topic: Constraints /Triggers
Next Topic: tablespace filled !
Goto Forum:
  


Current Time: Tue Mar 19 00:23:19 CDT 2024