Archives of the TeradataForum

Message Posted: Fri, 10 Apr 2009 @ 19:59:37 GMT

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

I like this:

     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

Vincent Bernard

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