Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   OBIEE - Teradata environment
From:   Anomy Anom

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


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?



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