I have a report table with the following index:
The table is around 30M records and it grows about 100K rows per day.
I want to use in the index above as a cluster, but as I understand I need to run the cluster table command each time that I want to cluster the data, otherwise new data isn't clustered.
Is there a way to define cluster index like SQL Server so that new rows are also clustered.
I cannot stop all my process each day (cluster needs an exclusive lock).
The query is:
select date,providerid,sum(*) from report_table where data < x and date > x group by date, providerid