Archives of the TeradataForum
Message Posted: Mon, 26 Jul 2010 @ 09:58:28 GMT
<-- 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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|