Archives of the TeradataForum

Message Posted: Mon, 22 Feb 2016 @ 14:44:54 GMT

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

Hi -- look in the Explain Logs. Limit the search to queries that involve select/read actions.

If U are not keeping a history of Explain Logs, then U need to begin immediately. 15 wks should be enough time to identify nonuse. Ideally, the timeframe for your search would include the fiscal year end for your organization.

We identified some JIs that were in longer in use with the approach above.

Good luck.

Rgrds,

Bill Gregg
Teradata DBA

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