__RecNo is an AUTO-INCREMENT BIGINT field, and is the only member of the
> > >PRIMARY key, sorted ASCENDING.
> > >
> > >The problem occurs on any index I use (string or INT), single or multiple
> > >keys.
> > >
> > > Occurs on
AIN SELECT * from wk004.slsf01 where ___RecNo > 3000 limit 1;
> EXPLAIN SELECT * from wk004.slsf01 where ___RecNo > 0 limit 1;
>
>> Fix:
>
>
>> Submitter-Id:jwythe
>> Originator: jww
>> Organization: Silk Systems Inc.
>> MySQL support: none
>&g
Inc.
>MySQL support: none
>Synopsis: SELECT using > and limit not optimized.
>Severity: serious
>Priority: medium
>Category: mysql
>Class: support
>Release: mysql-3.23.37 (Source distribution)
>Server: /usr/local/bin/mysqladmin Ver 8.19 Distrib 3
