Archives of the TeradataForum
Message Posted: Tue, 24 Sep 2002 @ 16:51:23 GMT
It's been a little while since I worked on a Teradata installation using Microstrategy (which was v7.1 I believe), but I know that we had some problems with performance too. Basically, caused by the SQL that Microstrategy was generating behind the reports - make sure that you've configured the VLDB Settings to take advantage of Teradata (i.e. enable volatile tables, derived tables, etc, as this worked wonders!!), and consider also any complex views that you've set-up on Teradata. If you do have some, it may be worth (if feasible) running these as tables to avoid the runtime hit when you access the view.
These are only guidelines that I can recall, and as I don't have access to MSTR now, can't really give you more detailed info than that. Hope it's something to work on though.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|