Archives of the TeradataForum
Message Posted: Fri, 10 Apr 2009 @ 20:10:32 GMT
Thanks for sharing this query as I too would like to find out if the secondary indexes are being used. However, why is my accesscount always zero? Is there something to turn "on" to collect the count? If so, the DBAs are unaware.
select tablename, indexname, indextype, sum(case when accesscount is null then 0 else accesscount end) as accesscount from dbc.indices where databasename = 'myDatabase' group by 1,2,3
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|