1CREATE TABLE taggings (pid, tag, tagger, PRIMARY KEY(pid, tag, tagger)); 2CREATE INDEX idx_pid ON taggings(pid); 3