在HSQLDB中禁用并重建索引 [英] Disable and rebuild an index in HSQLDB

问题描述

我想禁用（和以后重建）HSQLDB中给定表的所有索引。我知道这个功能从SQL Server，你可以只写

  ALTER INDEX ALL ON MyTable DISABLE; 
  

禁用表的所有索引，然后使用

  ALTER INDEX ALL ON MyTable REBUILD; 
  

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

$

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

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 does not have this feature.

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

这篇关于在HSQLDB中禁用并重建索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！