Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 24 Sep 2002 @ 16:51:23 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016