Can a small and frequently used table be cached?greenspun.com : LUSENET : DBAzine : One Thread
I have a small table of 25 mB that caused almost 99% I/O (physiocal read)in the database. It is not a problem of lack of indexes. It is just the fact that this table is most frequently used with all different DMLs(update, insert, delete, select). Can some one tell me if it is a good idea to cache this table in the database cache to reduce the I/O activity? Is it a good idea to cache a OLTP table with busy activity in the database cache? I know that this table will not grow too large as time goes by because at the end of a batch operation, all rows in this table will be deleted. Thanks for your help.
-- Mark Zhang (email@example.com), July 31, 2004