Re: Resetting highwatermark

From: Mike White <mwhite_at_icgconsulting.com>
Date: 1997/09/23
Message-ID: <609e9m$f0g$1@client3.news.psi.net>#1/1

Brian Rasmusson <br_at_belle.dk> wrote:

>> 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 ;-(

See page 206 of Guy Harrison's 'Oracle SQL High-Perfomance Tuning'. He discusses this problem and provides a very fast solution using cursors.
Mike White
The Image Consulting Group
mwhite_at_icgconsulting.com Received on Tue Sep 23 1997 - 00:00:00 CDT