From DB Browser of Toad for DB2, select multiple tables and right click to select Utilities. Select Runstats object options | distribution statistic. The generated script will only contain 'with distribution' on the 1st table as such:
RUNSTATS ON TABLE "BX"."TBX_UTL_STN"
ON ALL COLUMNS
WITH DISTRIBUTION AND
DETAILED INDEXES ALL
ALLOW READ ACCESS
SET PROFILE NONE;
RUNSTATS ON TABLE "BX"."TBX_USER"
ON ALL COLUMNS AND
DETAILED INDEXES ALL
ALLOW READ ACCESS
SET PROFILE NONE;
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center