Doesn't the B table contain large fields including attachments? ________________________________
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of ARSmarts Support Sent: Thursday, March 25, 2010 8:24 AM To: [email protected] Subject: Re: Question on H and T tables in Remedy Schema ** The H table contains the status history data. Best regards ARSmarts, your most useful AR System companion. www.ARSmarts.com <http://www.ARSmarts.com/> On 25 Mar 2010, at 16:16, Jim Coryat wrote: ** I have a quick question on the tables in the Remedy schema. I know that the T prefixed tables are the actual form data. What function do the H prefixed tables provide? Our EIE:Log form has over 60 million rows. We want to truncate the table and them implement purging for the form. Thinking we can implement the purging and have it purge the rows is not realistic. However I don't want to do this and have some other dependent forms start having issues because of this action. Jim Coryat Micron Technology Inc. ITIL v2 Practitioner Certified _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
