Re: HPL problem on 9.40

Jonathan, Thanks for the suggestion but when I tried the update method on a table with around a million rows the HPL job was about 3 times quicker. Do you or anyone else know of a way of finding the extent to which a table has been converted, i.e. something like a percentage of pages with the new format? Thanks, Andy Jonathan Leffler <jleffler@earthlink.net> wrote in message news:<YKO8c.1385$lt2.125@newsread1.news.pas.earthlink.net>... > Andy Watson wrote: > > Some more information on this problem and its symptoms: > > > > We're running a large number (172) of HPL unload jobs one after the > > other from the command line using onpladm. > > > > The unloads are being done to /dev/null as we only want the pages to > > be read into memory to force the header conversion that is performed > > on each page following an "onmode -BC 2" in 9.40. > > Hmmm...is that really quicker than: > UPDATE Sometable SET SomeColumn = SomeColumn;