Archives of the TeradataForum

Message Posted: Mon, 26 Jul 2010 @ 14:06:28 GMT

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

You can take the query and execute it separately to check if the time taken is due to the query at Teradata end or processing taking more time at OBIEE end.

Following options can be tried for performance:

- avoid multiple joins and try to have denormalized structure at Teradata end.

- Check the volume of the data of the report. If the no of records into consideration are beyond 5lac, it will have performance impact.

Thanks & Regards

Rishi Agarwal

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