SQLite Forum

Requesting optimization for index expression case
Login
I see. What about the second part of the question?

Related to this, even with the 2nd column present, the optimizer doesn't recognize that testIndex is a value way to perform:

```
SELECT length(x) FROM test
```
without explicitly forcing the INDEXED BY.