Re: Resetting highwatermark

> Assuming that the column you are referencing is indexed, the optimizer
> will use it to select min(column) OR max(column), but not both in the
> same statement!
>
> You may find it useful to issue two separate selects, one for the min()
> and one for the max()

Yes, i already do that, but still it is slow when i have had a lot of rows in the table ;-(

Regards
Brian

--
------------------------------------------------------------------------
Brian Rasmusson, Software engineer & analyst     e-mail: brianr_at_belle.dk
Belle Systems A/S                                web   : www.belle.dk
Network, Internet and communication specialists  phone : +45 59442500
------------------------------------------------------------------------