Archives of the TeradataForum

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

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

<-- 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>>