Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 26 Jul 2010 @ 09:58:28 GMT


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


Subj:   OBIEE - Teradata environment
 
From:   Anomy Anom

<-- Anonymously Posted: Monday, July 26, 2010 02:26 -->

Gurus,

Any clues on the best practices of OBIEE - Teradata environment?

We are facing problems like bad performance of the queries generated by OBIEE. (Spool space barrier hit multiple times)

Lot of joins in the query generated by OBIEE, not sure how to go about tuning the query.

2 approaches we are trying are ...

1. Is it better to construct the SQL on Teradata directly and populate a temp table so that OBIEE picks up data from that temp table directly reducing pressure on OBIEE?

2. Check on query tuning aspects in OBIEE itself?


Or any other methods?

any suggestions?


Regards

anom.



     
  <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: 15 Jun 2023