Archives of the TeradataForum

Message Posted: Fri, 10 Apr 2009 @ 20:10:32 GMT

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

Hello,

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.

Thanks,

Linda

     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

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