valdo404 / play-oauth-server Goto Github PK

/* `1` is pk.auth.CBType.TUser */
CREATE INDEX acc_by_email ON pk(email) WHERE tpe = 1 USING GSI;

/* `3` is pk.auth.CBType.TToken */
CREATE INDEX refresh_token ON pk(refreshToken) WHERE tpe = 3 USING GSI;

SELECT * FROM system:indexes;

EXPLAIN
    SELECT pk.* FROM pk USE INDEX (acc_by_email USING GSI)
    WHERE email LIKE 'abc@%' AND tpe = 1;

DROP INDEX pk.acc_by_email USING GSI;
CREATE PRIMARY INDEX ON pk USING GSI;
DROP PRIMARY INDEX ON pk USING GSI;