Forum Discussion
What are the best practices for managing and optimizing a SQL table that contains 10 million records
I have a table that currently holds 10 million records, and it continues to grow daily. As the dataset expands, I'm encountering significant challenges in retrieving data efficiently and generating r...
I'm not sure if this is the best practice, but I'm sharing what I do.
My SQL data table contains around 100 million rows. I analyze the key column used for filtering data (Mostly date in year/month/day) in reports and split the data across different physical disks (SAN) for storage. This approach makes it easier for me to detach data partition when I want to archive it.
Indexes and statistics are updated weekly.
