Page History
...
Some common questions about high-speed tables:
Q: What type of tables are candidates to be high-speed tables?
Broadly speaking, database tables that have the following characteristics are good candidates for high-speed table implementations:
...
EXEC_OS400 CMD('DLTUSRIDX DC@TBLIDX')
USE BUILTIN(REBUILD_FILE_INDEX) WITH_ARGS('''*ALL''')
Q: What happens when I change the layout of a table?
...