Re: [Firebird-devel] Firebird feature requests

[Vlad H. <hv...@us...>]

> 3) Create index
> create index myidx0 on mytable( status );
> 
> 4) Simulate some past table activity (important! do not skip this step)
> update mytable set status = 3 where status = 1;
> update mytable set status = 1 where status = 2;
> update mytable set status = 2 where status = 3;
> commit;

    You insert into index all possible key values for the each record
 
> 5) Please execute both queries below and compare time of execution:
>     a) select recid from mytable where status = 0;

    No keys with value of 0

>     b) select recid from mytable where status < 1;

    Index key with value 1 point to the each record in table 
because of garbage you create in step 4

Regards,
Vlad