Buffer Pool consist of various type of cache like data cache, plan cache, log cache etc. Here data cache is the very important part
of buffer pool which is used to store the various types of pages to serve particular query. Suppose if we run a particular select
query on a table to show all data rows of that table. Then all the data pages of that table will be required to fulfill the requirement
of this query. Here first all data pages will move from disk to buffer pool. This operation of reading data pages from disk to
memory is known as physical IO. But if we running the same query again then there is no need to read data pages from disk to
buffer pool because all the data pages are already in buffer pool. This operation is known as Logical IO.
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment