 |
 |
Archives of the TeradataForum
Message Posted: Tue, 24 Sep 2002 @ 16:51:23 GMT
| Subj: | | Re: Performance issue |
| |
| From: | | Dodgson, Mark |
Rajesh,
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.
Cheers,
Mark
| |
