I perform every month a massive load of data into the DB and It’s very important to reorganize all the tables before starting the loading procedures.

(There’s a way to reorganize all tables via DQL in a single command? – I would like to start the reorganization of the tables during the night)

The possibilities in DE8 is vast compared to earlier versions, but a lot of it is still to be unlocked for existing users….

I guess I can start the unlocking a little here:

The following script would reorganize all the tables in your database.

define "retval" text .

For $DeStat_DocInfo$ with DocumentType ="Form" and DocOwnerShip ="Defines" ;

retval := ExecDQL(concat("reorganize ", TableName , " ."),"","","","","") .

message concat("Currently Reorganizing: ", TableName ) .

end .