A large base table has a 4KB blocksize; a small reference table has a 1KB blocksize. Is this
performance strategy appropriate?
A.
Yes, the reference table can experience less cache interference.
B.
No, the 4KB blocks will dominate the disk process cache.
C.
Yes, a smaller blocksize can be searched faster.
D.
No, database tables should all use the same blocksize.