Curt Narvesen wrote in message <[log in to unmask]>... >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? I suggest you download David Greer and Alfredo Rego's "Howmessy is my Database" paper from: http://www.robelle.com/library/tutorials/ /Hans +------------------------------------------ | Hans Hendriks Robelle Consulting Ltd | mailto:[log in to unmask] (888) 762-3553 | http://www.robelle.com/~hans