Explain procedure cache and data cache in Sybase.

1.	Explain procedure cache and data cache in Sybase.
Answer» Procedure cache is NOTHING but the memory AREA where the compiled QUERY tree is running. Data Cache is also a memory area where the RELEVANT data required for the currently running queries is bought from the Disk memory to BUILD result sets.

Discussion