C
ChUIMonster
Guest
Yes. Putting those tables into *dedicated* storage areas with appropriately sized rows per block will improve overall performance. One storage area per table for the data. Set RPB to dbBlockSize / (avgRowSize + 20 ) (get that from dbanalys). Put the indexes into dedicated storage areas corresponding to the tables. It is ok to have multiple indexes per area. It is not quite as good as upgrading to OE11 and converting to Type 2 areas -- but it is close. I don't think splitting data and indexes into their own areas is at all controversial. There is occasionally some "spirited discussion" about the appropriate rows per block for index areas. Some argue for "1" since there is no data. Others say that if you mess up and accidentally put data in an index area then it is better to have a reasonable default value such as 128.
Continue reading...
Continue reading...