adilsonrapozojr
2/8/2020 - 6:48 PM

Db2 force index usage

force-index-volatile.sh
content_copyfile_download
# MAKING TABLE VOLATILE
db2 alter table SCHEMA.TABLE volatile
db2 flush package cache dynamic

# REMOVING VOLATILE
db2 alter table SCHEMA.TABLE not volatile
db2 flush package cache dynamic