One thing be sure that On the requestor console you will not be able to retrieve old tickets which are closed against a user.
Instead of deleting it go for archiving the form If you think end user will not be interested to have look @ the old ticket which he/ she has raised then going for deletion will be good as this will bring down the database size a bit and processing/retrieving of data time on the consolidate form will be less Regards Rajesh ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rick Cook Sent: Wednesday, October 27, 2010 6:49 PM To: [email protected] Subject: Re: Share Consolidated List ** Absolutely! Set an escalation to do this weekly or something. Rick On Oct 27, 2010 6:09 AM, "Frank Caruso" <[email protected]<mailto:[email protected]>> wrote: > ARS 6.3 > Help Desk 6.0 > Oracle > > Would it make sense to run an escalation to delete SHR:ConsolidatedRecords > after and issue has been Closed, maybe after 30 days? > > There are a very large number of records in that table and we are seeing > some performance issues that could be caused by queries against that table. > > Thank you > > Frank > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at > www.arslist.org<http://www.arslist.org> > attend wwrug11 www.wwrug.com<http://www.wwrug.com> ARSList: "Where the > Answers Are" _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ ________________________________ Important notice: This e-mail and any attachment there to contains corporate proprietary information. If you have received it by mistake, please notify us immediately by reply e-mail and delete this e-mail and its attachments from your system. Thank You. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
