Archives of the TeradataForum

Message Posted: Fri, 18 Mar 2005 @ 20:02:58 GMT

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

Hi all,

I enable the ObjectUseCountCollectRate field in the DBS Control Utility to have a idea which object are use and which one seem to be less popular.

Is not very easy to interprete the number, it's seem than :

a field use in a where clause does not add 1 to AccessCount

a field use in a join does not add 1 to AccessCount.

I did request with view and the Accesscount never incremented by 1.

Does anybody have found any rule when the system add 1 to AccessCount? Is there a problem with this option.

Rudel Simard

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