1CREATE TABLE data ( 2 subject TEXT NOT NULL, 3 predicate TEXT NOT NULL, 4 object TEXT NOT NULL, 5 graph TEXT NOT NULL 6) CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ENGINE InnoDB; 7 8-- index for subject-primary retrieval (index prefixes: s, sp) 9CREATE INDEX idx_spo ON data(subject(32), predicate(32), object(32)); -- Prefix length is arbitrary 10 11-- index for predicate-primary retrieval (i.e. property fetch) 12CREATE INDEX idx_pso ON data(predicate(32), subject(32), object(32)); -- Prefix length is arbitrary 13