On 11/5/20 7:49 AM, Vasu Madhineni wrote:
Hi All,
In my organisation a newly built project application team requirement on tables like have a column (text type), with size can reach around 3 MB, and 45 million records annually.
Are there any specific precautions/prerequisites we have to take from DBA end to handle this type of table.
Think about partitioning it by date. Indexes will be smaller, and archiving become trivial.
--
Angular momentum makes the world go 'round.