Re: Performace question

Evan wrote:

>Is there any other way to reduce
>high water mark?

Look up the Create Table As Select syntax. Block all the other processes, CTAS all the records from the problem table, truncate the table, then insert into the table from a select from the new table.

I know you said you can't truncate, but this should be very fast in a script, so you need to establish a maintenance window with your site. How you block the processes is up to you.

jg

--
@home.com is bogus.
http://www.neowin.net/forum/index.php?showtopic=272750&st=0&#entry585309992