On 17 Mar 2017, at 10:20am, Rob Willett <[email protected]> wrote:
> CREATE INDEX "Disruptions_idx4" ON Disruptions ("status" COLLATE NOCASE ASC);
>
> […]
>
> As part of the larger more complex query, we are executing the query
>
> ```
> select * from Disruptions where status = 2 OR status = 6;
The schema for the table says that "status" is INTEGER.
You are supplying numbers as arguments.
Those two match and should create no problem.
But your index has a collation order which is usually used for text. I don’t
see that it is obviously wrong, but it does look a little weird.
Try creating another index which is just on "status", without the COLLATE
clause.
Then do another ANALYZE, then try the SELECT again.
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
