-- The outcome with no indices
select * from nellraw where entity='concept:food:kefir';
-- Time: 9944.937 ms

-- Creating an index
ALTER TABLE nellraw
ADD PRIMARY KEY (entity, relation, value);
-- The outcome with clustered indices.
select * from nellraw where entity='concept:food:kefir';
-- Time: 0.970 ms

-- With no unclustered index
SELECT count(*) FROM nellraw WHERE iteration = 171;
-- Time: 9481.160 ms

-- Creating a unclustered index
CREATE INDEX nellraw_secondary ON nellraw (iteration);
-- With unclustered index
SELECT count(*) FROM nellraw WHERE iteration = 171;
-- Time: 164.790 ms

