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