View Single Post
  #10 (permalink)  
Old November 28th, 2007, 17:53
chad chad is offline
Junior Member
 
Join Date: Feb 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
chad is on a distinguished road
Re: Purging and Archiving

I have our dba checking into pinning those packages.

We have just over 3.5M records in the OR_refnum table. Most of our BM queries are SQL queries that take about 30 sec. just to run against the db.

Do you use the app. purge process?
Reply With Quote