1CREATE TABLE data (
2    subject TEXT NOT NULL,
3    predicate TEXT NOT NULL,
4    object TEXT NOT NULL,
5    graph TEXT NOT NULL
6);
7
8-- index for subject-primary retrieval (index prefixes: s, sp)
9CREATE INDEX idx_spo ON data(lower(subject), lower(predicate), lower(object));
10
11-- index for predicate-primary retrieval (i.e. property fetch)
12CREATE INDEX idx_pso ON data(lower(predicate), lower(subject), lower(object));
13