Table 10-6 shows whether or not SQL is executable during a rebalance operation.
Table 10-6 Whether or not SQL is executable during a rebalance operation
SQL statement | Rebalance operation | While rebalance operation is underway or stopped | |
---|---|---|---|
Shared mode | Exclusive mode | ||
SELECT statement | Y | ![]() | Y |
UPDATE statement | Y1 | ![]() | Y1 |
INSERT statement | Y2 | ![]() | Y2 |
DELETE statement | Y | ![]() | Y |
LOCK statement | Y | ![]() | Y |
PURGE TABLE statement3 | ![]() | ![]() | Y |
DROP TABLE | ![]() | ![]() | Y |
CREATE INDEX | ![]() | ![]() | Y |
DROP INDEX | ![]() | ![]() | Y |
ALTER TABLE | ![]() | ![]() | ![]() |