Facing Spool related issues for the reports submitted to TERADATA by MICROSTRATEGY

Teradata Applications

Facing Spool related issues for the reports submitted to TERADATA by MICROSTRATEGY

Hello,

We are facing lot of spool related issues due to the reports submitted by microstrategy to TERADATA database. There are about 50 steps in each rreport submitted by microstrategy and the indexing is good so there is minimal scope of hot amp situation. 80% of these steps join to two tables one is daily sales and the other is item table, The steps involve in creating volatile tables and isnerting data into these volatile tables from the above two tables.Can anyone please provide your suggestions?

Thanks,

Raghu.

Tags (1)