Thank you for your reply!

My situation is that i want to find the perfect balance between performance and data loads and maintenance.

For the query performance issue, i was thinking that if the query is made based on the filter indexation_day, which is the partitioning key, it should work better with the partitioned table, than the case where the table is not partitioned and i only have a non-clustered index on indexation_day.

The reason I presented my table and the every day flow, was also to find out some views on this issue.

Thank you!