db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John English <john.fore...@gmail.com>
Subject Re: Using indexes
Date Tue, 28 Sep 2021 19:16:59 GMT
On Tue, 28 Sep 2021, 17:52 Rick Hillegas, <rick.hillegas@gmail.com> wrote:

> Glad that you have made progress on this puzzle. One comment inline...
>
> On 9/28/21 4:10 AM, John English wrote:
> > The WHERE clause seems to prevent the index from being used.
> The index is not usable in this query because username is not the
> leading column in the index.
>

Ah, right.

>

Mime
View raw message