[sqlite] Strange case in 3.2.7 , why Index create on multiple column isn't faster than index created on Single column

I have a Table with about 800,000 record DB Version : 3. 2. 7 The Sql looks like select x, y, sum(z)/1000 as bw from aa where a=1 and b=1 and c =1 and d= 6 group by x, y having count(*) > 1 order by bw desc limit 10 Column "d" is all set to 6 1/3 of

[sqlite] Strange case in 3.2.7 , why Index create on multiple column isn't faster than index created on Single column

I have a Table with about 800,000 record DB Version : 3. 2. 7 The Sql looks like select x, y, sum(z)/1000 as bw from aa where a=1 and b=1 and c =1 and d= 6 group by x, y having count(*) > 1 order by bw desc limit 10 Column "d" is all set to 6 1/3 of