This is going to cause you more headaches than it's worth and I don't think there will be any benefit so far as performance. If you want to see a performance benefit, try these things - remove all the lob/text columns from the table. - remove all the columns from the table that are not being used
Axton Grams On Jan 8, 2008 12:59 PM, LJ LongWing (Head) <[EMAIL PROTECTED]> wrote: > ** remember in 7.x they increased the size of the logon field from 30 to > 254 (or was it 255)...so that is actually a good size for a field that holds > login ID....but if it's a zTmp...is it a display only field? If it is then > it's length doesn't matter...you could set it to 0 if you wanted....if you > are looking to shrink the size of your DB, I believe shrinking the size of > the column will help...but I also think it's dependent upon your DB and how > it handles such column size changes. > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *John Kovalcik > *Sent:* Tuesday, January 08, 2008 10:49 AM > *To:* [email protected] > *Subject:* Large Character Fields > > ** > Listers, > > I have quite a few character fields that are 255 characters in > length. The majority of them came with the Helpdesk application and are in > the 25xxxxxxx field ID range. Would there be any performance benefit in > reducing these to only the necessary size. For example, a zTmp field at 254 > that holds only a login ID. Any insight would be appreciated. > > > > Thanks, > John M. Kovalcik > Service Management Sr. Analyst > ITIL Foundations Certified > Global Information Technology > Kennametal Inc. > 1600 Technology Way > > Phone: 724-539-5228 > Fax: 724-539-5797 > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
