I have a big database (200GB+) that contains some log info. And I want to speed up SELECT queries and stored procedures. I have a table with a GeneratedOnUtc datetime column, and have a non-clustered index on it.
I'm thinking to change it on clustered index.
Reasons to do it:
Big amount of data (40kk of rows)
Column is used in multiple
Whereclauses (between,>,<)Column is used in
ROW_NUMBER() OVER(ORDER BY d.GeneratedOnUtc asc) AS Rowqueries
Reason to not do it:
- Large amount of inserts (~60k per day) can lead to frequent B-tree rebuilds.
Please, advice.
Aucun commentaire:
Enregistrer un commentaire