Archives of the TeradataForum

Message Posted: Fri, 10 Apr 2009 @ 20:30:18 GMT

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

I believe it may be hard to tell with 100% certainty. The dbc.DBQLObjTbl may not contain all of your SQL statements if logging is not turned on for every user or if threshold logging is enabled where you don't get ever SQL statement which is under the threshold specified. (I assume you move the "dbc" data into the "PMCPData" database nightly and would look there for long term analysis).

I don't know much about the dbc.Indices column accesscount, but I know you have to enable it's use, otherwise the count will always be NULL. Enable it by setting the ObjectUseCountCollectRate field in the DBS Control Utility. A note from the manual: "Collecting use counts, like access logging, is resource-intensive. Enable this feature only if necessary, and set the collection rate as needed".

Jim

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