在HSQLDB中禁用并重建索引(Disable and rebuild an index in HSQLDB)

在HSQLDB中禁用并重建索引(Disable and rebuild an index in HSQLDB)

我想禁用（以及稍后重建）HSQLDB中给定表的所有索引。 我从SQL Server知道这个功能，您可以在其中编写

ALTER INDEX ALL ON MyTable DISABLE;

禁用表的所有索引，然后使用重建它们

ALTER INDEX ALL ON MyTable REBUILD;

如果HSQLDB支持禁用和启用单个索引，我甚至不确定。

I would like to disable (and later rebuild) all indexes for a given table in an HSQLDB. I know this feature from SQL Server, where you can just write

ALTER INDEX ALL ON MyTable DISABLE;

to disable all indexes for a table and then rebuild them with

ALTER INDEX ALL ON MyTable REBUILD;

I am not even sure, if HSQLDB supports disabling and enabling a single index.

最满意答案

HSQLDB没有此功能。

您可以执行SHUTDOWN COMPACT以在所有表​​上重新创建所有索引。

HSQLDB does not have this feature.

You can perform SHUTDOWN COMPACT to recreate all indexes on all tables.