mardi 27 janvier 2015

Index based of timestamp


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 Where clauses (between, >, <)




  • Column is used in ROW_NUMBER() OVER(ORDER BY d.GeneratedOnUtc asc) AS Row queries




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