Performance problems with MicroStrategy queries using Volatile tables
I am seeing MicroStrategy queries having CPU SKEW and Disk SKEW of 95% or greater. This is of course causing a performance problem on the database. The common denominator with the queries is that all of them are using volatile tables. Has anyone seen this type of behaviour and possibly know of any ways to either resolve or help to identify exactly what the problem is? Unfortunately I am not MicroStrategy knowledgable and only been doing Teradata DBA work for slightly over a year.