Performanzproblem

Code: Alles auswählen.

SELECT (pa_spalt) from (gd_tablename)
             into <fs_temp>
             GROUP BY (lv_group).
  IF <fs_temp> IS INITIAL.
    CONCATENATE gv_spaltenname ' = ' '<fs_temp>' INTO lv_spalte SEPARATED BY SPACE.
*    CONCATENATE gv_spaltenname  ' IS NULL'  INTO lv_spalte.
    ELSE.
   CONCATENATE gv_spaltenname ' = ' '<fs_temp>' INTO lv_spalte SEPARATED BY SPACE.
  ENDIF.
  CREATE DATA ls_ergebnis-lv_tabspalte type (zeile-rollname).
  ASSIGN ls_ergebnis-lv_tabspalte->* TO <fs_tabspalt>.
  SELECT COUNT( * )
         from (gd_tablename)
         into count
         where (lv_spalte).
    <fs_tabspalt> = <fs_temp>.
    ls_ergebnis-number = count.
*  WRITE:/ 'Spalte:',lv_augrp,'  ', 'Anzahl:',count.
  APPEND ls_ergebnis TO lt_ergebnistab.
 ENDSELECT.

Code: Alles auswählen.

CONCATENATE gv_spaltenname 'COUNT( * ) ' into lv_select SEPARATED BY SPACE.
SELECT (lv_select)
         from (gd_tablename)
         into TABLE lt_ergebnistab PACKAGE SIZE 1000
         GROUP BY (lv_group).
ENDSELECT.