Skip to Content
Former Member
Oct 21, 2008 at 12:03 PM

BPS read very slow - possibility to change SQL / execution plan for cube?



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?

Thank you.

Regards, Lars.