Interested to Buy Any Domain ? << Click Here >> for more details...
What is buffrpool? Where we use it ?
- 2 Answers
- 13845 Views
- Tesco, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
Bufferpools are areas of virtual storage where DB2
temporarily stores the pages of tablespaces and indexes.
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / pavan grandhi
Buffer pool is a process of caching currently retrieved or
probable pages for retrieval from secondary storage (hard
disks, drums etc.), on to the primary storage.
It is for faster read/write cycles.
Used in OS/RDBMS, DB2 too.
| Is This Answer Correct ? | 2 Yes | 2 No |
What is RUNSTATS?
What is node in db2?
What is database manager in db2?
How to resolve deadlock issue
What is a view? Why use it?
What is index cardinality?
What keyword does an SQL SELECT statement use for a string search?
How can you quickly find out the number of rows updated after an update statement?
What is the difference between using bind () and rebind () methods of naming class?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
What is the syntax required for the creation of a cursor?
Are views updatable ?
COBOL 
