Re: [sqlite] sqlite 3.13.0 does not use indexes as 3.8.11.1 does

l2,kVAhl3, ...> PFsys,PFl1,PFl2,PFl3,Wdmd,vardmd,VAdmd ...> FROM hst_energy_d ...> WHERE enflag = 0 ORDER BY recdate DESC, rectime DESC LIMIT 1; 0|0|0|SCAN TABLE hst_energy_d 0|0|0|USE TEMP B-TREE FOR ORDER BY For me is OK regards Alessandro ---

[sqlite] sqlite 3.13.0 does not use indexes as 3.8.11.1 does

,kWhnl2, kWhnl3,kVAh,kVAhl1,kVAhl2,kVAhl3, PFsys,PFl1,PFl2,PFl3,Wdmd,vardmd,VAdmd FROM hst_energy_d WHERE enflag = 0 ORDER BY recdate DESC, rectime DESC LIMIT 1; --- Alessandro Fardin Carlo Gavazzi Controls SpA - R Via Cima i Prà, 9/H 32014