Posted On: Feb 22, 2018
The buffer pool is an area in main memory where InnoDB caches table and index data as it is accessed. The buffer pool permits frequently used data to be processed directly from memory, which speeds up processing. On dedicated servers, up to 80% of physical memory is often assigned to the buffer pool.
Never Miss an Articles from us.
DB2 is a huge relational database management system for the MVS (Multiple Virtual storages) operating systems, where th..
The data types used in DB2 are: SMALLINT DECIMAL CHAR FLOAT INTEGER VARCHAR DATE TIME ..
PACKAGE:They are units, which consists of many executable codes that are meant for SQL statements for one respective DB..