Explain procedure cache and data cache in sybase.



Explain procedure cache and data cache in sybase...

Answer / Sulekha Kumari

Procedure cache in Sybase is a memory space used to store compiled procedures, reducing the time required for future executions. Data cache, also known as buffer pool, stores recently accessed data pages to minimize disk I/O. Both help improve overall database performance.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Sybase Interview Questions

What is sybase ?

1 Answers  


How does sybase replication work?

1 Answers  


Explain table partitioning in sybase.

1 Answers  


What is a temp table? how to denote temp table?

4 Answers   Oracle,


How do I correct time slice -201?

1 Answers  


You want to delete a table in sybase. How would you do it?

1 Answers  


How to start sybase database in windows?

1 Answers  


When are stored procedures compiled in sybase?

1 Answers  


How do I move tempdb off of the master device?

1 Answers  


Are you doing the updates from within a cursor?

1 Answers  


What is isql in sybase?

1 Answers  


List different types of sybase index.

1 Answers  


Categories