2013/8/26 Florian Weimer <fwei...@redhat.com> > On 08/26/2013 04:27 PM, Torello Querci wrote: > >> Create index statement that I use is: >> >> CREATE INDEX dati_impianto_id_tipo_dato_id_**data_misurazione_idx >> ON dati >> USING btree >> (impianto_id , tipo_dato_id , data_misurazione DESC); >> > > What are the data types of these columns? > > impianto_id -> integer tipo_dato_id -> integer data_misurazione -> date
The index was present in the database before I drop it since one about year and half.