What is procedure cache and data cache?

  • Interview Candidate
  • 3
  • 4227

Showing Answers 1 - 3 of 3 Answers

kurar

  • Mar 9th, 2008
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions