[sqlite] 回复： Re: [sqlite] About Index using

Hi Drh I just found a strange case , can you give me some explaination ? 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

[sqlite] 回复： Re: [sqlite] About Index using

Hi Nathan I just found a strange case , can you give me some explaination ? 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

[sqlite] 回复： Re: [sqlite] About Index using

thanks a lot for your help ! Nathan Kurz <[EMAIL PROTECTED]> 写道： On Mon, Dec 12, 2005 at 09:48:21AM +0800, Bo Lin wrote: > Here is a sql string ,like : select * from test where (a=0 or a=1) > and b=1 ; and column a range from 1-1, and column b range from > 0-1. and DB has about 300,000