CREATE TABLE txn (txn_id INT PRIMARY KEY AUTO_INCREMENT, account VARCHAR(64), amount INT);
ALTER TABLE txn ADD INDEX i1 (account);