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 |
What is sybase ?
How does sybase replication work?
Explain table partitioning in sybase.
What is a temp table? how to denote temp table?
How do I correct time slice -201?
You want to delete a table in sybase. How would you do it?
How to start sybase database in windows?
When are stored procedures compiled in sybase?
How do I move tempdb off of the master device?
Are you doing the updates from within a cursor?
What is isql in sybase?
List different types of sybase index.
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)