R
Rob Fitzpatrick
Guest
In my opinion, it would be "simpler" to have fewer areas, not more. I wouldn't enjoy reading a dbanalys report in a 500-table DB with 1000+ areas. And I second all of Tom's points. Create separate areas only when they're needed for practical purposes. Since opportunities to restructure large databases tend not to come along very often, it's worth asking about things you can only address via dump and load. Are you using optimal DB block size, area RPBs, and cluster sizes? Are there unresolved application performance issues?
Continue reading...
Continue reading...