Resetting highwatermark

Hi,

is it possible to reset the highwatermark of a table? I cannot drop or truncate the table as it is in use constantly.

What i have is a transaction table, where one process writes, and one reads and deletes.

I only process a limited number of transactions at a time, and i find a range by selecting min and max ids of the rows. Problem is if the read/delete process has been down for a period, lots of transactions will be written to the table, thus setting the highwater mark.

Now, if there have been, say, 800.000 transactions in the table, but there
normally is only around 5000, the selection of min and max will be very slow. Is there any way to get around this?

Best 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


------------------------------------------------------------------------