Subject Re: SV: [firebird-support] select fieldA >= xxx is very very slow on Big table ?
Author Michael Ludwig
Post date 2010-12-20T10:53:01Z
Vander Clock Stephane schrieb am 20.12.2010 um 13:07 (+0300):

> PLAN (HASH INDEX (HASH_X1_Y1_IDX))
> PLAN (RDB$DATABASE NATURAL)
>
> Indexed Read: 172
> Non Indexed Read: 1

How do you get these last two extra lines?

I have SET PLAN ON and SET STATS ON but I don't get those lines.

SQL> SHOW VERSION;
ISQL Version: WI-V2.5.0.26074 Firebird 2.5

--
Michael Ludwig