we run a job every night updating about half a milltion records in a cube with
2 Millionen records. This job runs more than three hours. The analysis shows
the the main bottle neck is the database query. We already tried to do the data into quite small data packages.
Compression is done, indexes are alright, database statistics are refreshed s.o.
Is there a possiblity to influence the sql query BPS sends to the database or influence the execution plan of the query to get a better performance?