Re: [Firebird-test] select MAX() not used INDEXES to run

[Robbi <ess...@gm...>]

Hi Carlo,

a first hint: this is normal IB/FB behaviour AFAIK (for MIN,MAX, COUNT,
...?)!
It is reasoned by the multi generation architecture. The MGA can hold
several generations of records with always the same index identifier. But at
the moment I cann't explain you more details.

Robbi


""Carlo Pires"" <ca...@ug...> schrieb im Newsbeitrag
news:a3bc4n$sdq$1...@ne......
> Hi,
>
> I'm testing firebird with a table with 65000 records. When I try to:
>
> select MAX(COD_VALUE) from TABLE_TEST;
>
> The plan used by firebird is NATURAL. This is strange to me because I have
a
> index for field COD_VALUE. I had to implement a stored procedure + a
> descending index for field COD_VALUE to get, more quickly, the max value
for
> COD_VALUE.
>
> Know anyone about this? I'm wrong ?
>
> -Carlo
>
>
>
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
>