Archives of the TeradataForum

Message Posted: Mon, 18 Nov 2014 @ 02:13:05 GMT

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

One of the possible reason for high parse time is that the user id that you are using for querying DBQL tables might have several roles assigned to it. Having too many roles causes increase in parsing time.

Try executing the same query with a different user id which has fewer roles/privileges.

Thanks

Abhishek Jadhav

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