CREATE INDEX pidx1 ON t(a) WHERE b >= 100 and b <= 200;
CREATE INDEX qidx1 ON t(b) WHERE b >= 100 and b <= 200;
CREATE INDEX ridx1 ON t(c) WHERE b >= 100 and b <= 200;
CREATE INDEX sidx1 ON t(d) WHERE b >= 100 and b <= 200;
CREATE INDEX pidx2 ON t(a) WHERE b >= 100 and b <= 200;
CREATE INDEX qidx2 ON t(b) WHERE b >= 100 and b <= 200;
CREATE INDEX ridx2 ON t(c) WHERE b >= 100 and b <= 200;
CREATE INDEX sidx2 ON t(d) WHERE b >= 100 and b <= 200;
CREATE INDEX pidx3 ON t(a) WHERE b >= 100 and b <= 200;
CREATE INDEX qidx3 ON t(b) WHERE b >= 100 and b <= 200;
CREATE INDEX ridx3 ON t(c) WHERE b >= 100 and b <= 200;
CREATE INDEX sidx3 ON t(d) WHERE b >= 100 and b <= 200;
CREATE INDEX pidx4 ON t(a) WHERE b >= 100 and b <= 200;
CREATE INDEX qidx4 ON t(b) WHERE b >= 100 and b <= 200;
CREATE INDEX ridx4 ON t(c) WHERE b >= 100 and b <= 200;
CREATE INDEX sidx4 ON t(d) WHERE b >= 100 and b <= 200;
CREATE INDEX pidx5 ON t(a) WHERE b >= 100 and b <= 200;
CREATE INDEX qidx5 ON t(b) WHERE b >= 100 and b <= 200;
CREATE INDEX ridx5 ON t(c) WHERE b >= 100 and b <= 200;
CREATE INDEX sidx5 ON t(d) WHERE b >= 100 and b <= 200;
CREATE INDEX pidx6 ON t(a) WHERE b >= 100 and b <= 200;
CREATE INDEX qidx6 ON t(b) WHERE b >= 100 and b <= 200;
CREATE INDEX ridx6 ON t(c) WHERE b >= 100 and b <= 200;
CREATE INDEX sidx6 ON t(d) WHERE b >= 100 and b <= 200;
CREATE INDEX pidx7 ON t(a) WHERE b >= 100 and b <= 200;
CREATE INDEX qidx7 ON t(b) WHERE b >= 100 and b <= 200;
CREATE INDEX ridx7 ON t(c) WHERE b >= 100 and b <= 200;
CREATE INDEX sidx7 ON t(d) WHERE b >= 100 and b <= 200;
CREATE INDEX pidx8 ON t(a) WHERE b >= 100 and b <= 200;
CREATE INDEX qidx8 ON t(b) WHERE b >= 100 and b <= 200;
CREATE INDEX ridx8 ON t(c) WHERE b >= 100 and b <= 200;
CREATE INDEX sidx8 ON t(d) WHERE b >= 100 and b <= 200;
CREATE INDEX pidx9 ON t(a) WHERE b >= 100 and b <= 200;
CREATE INDEX qidx9 ON t(b) WHERE b >= 100 and b <= 200;
CREATE INDEX ridx9 ON t(c) WHERE b >= 100 and b <= 200;
CREATE INDEX sidx9 ON t(d) WHERE b >= 100 and b <= 200;
CREATE INDEX pidx10 ON t(a) WHERE b >= 100 and b <= 200;
CREATE INDEX qidx10 ON t(b) WHERE b >= 100 and b <= 200;
CREATE INDEX ridx10 ON t(c) WHERE b >= 100 and b <= 200;
CREATE INDEX sidx10 ON t(d) WHERE b >= 100 and b <= 200;

ANALYZE t;
