1. Describe the four different types of table growth patterns and maintenance concerns associated with each.
- Continuous growth
- High volume of INSERT activity
- Few DELETES
- Value of data wanes with age
- Because newest rows are "hottest", good performance occurs if indexing strategy avoids older rows
- Clustered index on sequential value (PK or timestamp)
- A query that touches most rows before filter
- Performance will degrade over time