Re: SQL on V4: Index Optimization (Hobbyist question)

[Patrik Schindler <poc@xxxxxxxxxx>]

Hello,

apparently, I did a copy-paste error.


Am 27.03.2021 um 13:07 schrieb Patrik Schindler <poc@xxxxxxxxxx>:

> SELECT ucword FROM ucwrdlstpf WHERE ucword LIKE 'Q__AS%'
>
> gives a result in around three seconds. :-O This is *a lot* less than before, with some dozen seconds before. (Three seconds might seem much, but remember, we're talking about a 150 here.)
>
> Problem solved. Thanks a lot for great your help and valuable input!

Wrong! I used the wrong test string. It should have been

SELECT ucword FROM ucwrdlstpf WHERE ucword LIKE '______C_U%'

And indeed, with that and the per-char indexes, a full-table scan happens.

Sorry for the confusion.

:wq! PoC