Answer Detail: RE: What is procedure cache and data cache?

GeekInterview.com > Interview Questions > Database > Sybase

Print |

Question: What is procedure cache and data cache?

March 03, 2008 08:39:19	#1
kurar	Member Since: March 2008 Total Comments: 1
RE: What is procedure cache and data cache?
Procedure cache is the memory area where compiled query tree run e.g, procedure, batch query. Data Cache is the memory area where data that is required for the current querys running is bought from Disk on to memory for building result sets.