Для перебудови індексу послідовно виконують команди:

Question

Accepted Answer

ALTER INDEX nameindex INACTIVE; ALTER INDEX nameindex ACTIVE

Accepted Answer

DROP INDEX nameindex; CREATE INDEX nameindex ON nametable

Answer

CREATE INDEX nameindex ON nametable; SET STATISTICS INDEX nameindex

Answer

CREATE INDEX nameindex ON nametable; ALTER INDEX nameindex ACTIVE

Answer

DELETE INDEX nameindex ON nametable; ALTER INDEX nameindex INACTIVE

Crowdly