DROP INDEX IF EXISTS idx_lulc_id;
CREATE INDEX idx_lulc_id ON lulc USING btree(osm_id DESC) TABLESPACE vgi;

DROP INDEX IF EXISTS idx_lulc_type;
CREATE INDEX idx_lulc_type ON lulc USING btree("type") TABLESPACE vgi;

DROP INDEX IF EXISTS idx_lulc_class_code; 
CREATE INDEX idx_lulc_class_code ON lulc USING btree(class_code) TABLESPACE vgi;

DROP INDEX IF EXISTS idx_lulc_timestamp; 
CREATE INDEX idx_lulc_timestamp ON lulc USING btree("timestamp" DESC) TABLESPACE vgi;

DROP INDEX IF EXISTS idx_lulc_the_geom;
CREATE INDEX idx_lulc_the_geom ON lulc USING gist(the_geom) TABLESPACE vgi;

VACUUM ANALYZE lulc;