Look at the main key. The main key of the data set may not be the one that is used most of the time. I have changed main keys on a data set with out having to change any programs. Rich Holloway Systems Administrator Providence Health Plans Phone: (503) 574-7457 Fax: (503) 574-8614 [log in to unmask] The opinions expressed are not necessarily those of my company. They belong solely to me. If everything seems under control, you're just not going fast enough. -- Mario Andretti > -----Original Message----- > From: Curt Narvesen [SMTP:[log in to unmask]] > Sent: Wednesday, March 10, 1999 7:09 AM > To: [log in to unmask] > Subject: Howmessy Help > > I have a client with performance problems on their database. I have > run a how > messy report and identified several datasets that could use repacking > based upon > the elongation values. Besides adding or deleting paths, is there > anything else > that I can look at to help improve their database efficiency? > > > Thanks, > > Curt