I have an application that queries and writes to 11 normalized tables. While performance testing, I noticed that when I put all of the tablespaces used by these tables in the same 32K buffer pool, the application ran much faster than when I allocated separate buffer pools. Each table is in its own t
Read More - Register for Free Membership