CREATE TABLE t1 (
a int PRIMARY KEY,
b varchar(32),
c int NOT NULL
) ENGINE = NDB;
INSERT INTO t1 VALUES
(1, "MySQL Server with NDB", 3),
(3, "The third row", 9),
(37, "And of course number 37", 37);
SELECT a FROM t1 WHERE c > 8 ORDER by c;
a
3
37
ALTER TABLE t1 ALGORITHM=INPLACE, ADD INDEX c_idx1(c);
SELECT a FROM t1 WHERE c > 8 ORDER by c;
a
3
37
DROP TABLE t1;