SQL-Stmt

Hallo Zefrim,

wie wäre es mit

SELECT TB.CREATOR, TB.NAME, COUNT(IX.NAME)
FROM SYSIBM.SYSTABLES TB
,SYSIBM.SYSINDEXES IX
WHERE TB.TYPE = ‚T‘
AND TB.CREATOR = IX.TBCREATOR
AND TB.NAME = IX.TBNAME
GROUP BY TB.CREATOR, TB.NAME
;

Tschüß
Christian

SELECT TB.CREATOR, TB.NAME,
SUM( CASE WHEN IX.NAME IS NULL THEN 0 ELSE 1 END) "SUMME-IX"   
  FROM SYSIBM.SYSTABLES TB LEFT JOIN                  
      SYSIBM.SYSINDEXES IX                  
ON TB.TYPE    = ‚T’                     
   AND TB.CREATOR = IX.TBCREATOR            
   AND TB.NAME    = IX.TBNAME               
GROUP BY TB.CREATOR, TB.NAME         
;