for DB2 database: RUNSTAT for every table after it was filled and indexes created

pydiverse / pydiverse.pipedag

A data pipeline orchestration library for rapid iterative development with automatic cache invalidation allowing users to focus writing their tasks in pandas, polars, sqlalchemy, ibis, and alike.

https://pydiversepipedag.readthedocs.io/

BSD 3-Clause "New" or "Revised" License

15 stars 2 forks source link

for DB2 database: RUNSTAT for every table after it was filled and indexes created #112

Closed windiana42 closed 8 months ago

windiana42 commented 11 months ago

CALL SYSPROC.ADMIN_CMD('RUNSTATS ON TABLE schema.table ON ALL COLUMNS WITH DISTRIBUTION ON ALL COLUMNS AND UNSAMPLED  DETAILED INDEXES ALL SET PROFILE');

This command is also necessary to enable indexes

nicolasmueller commented 9 months ago

Should this be called before or after indices are created?

This command is also necessary to enable indexes

Seems ambiguous to me.

nicolasmueller commented 9 months ago

The documentation seems to imply that after index creation is better, so I'll go with that: https://www.ibm.com/docs/en/db2/11.5?topic=commands-runstats