Answer / Faheem Husain

Procedure Cache stores compiled stored procedures, while Data Cache stores the actual data. Procedure Cache improves performance by avoiding recompilation of frequently used stored procedures, and Data Cache reduces the need for disk I/O by keeping recently accessed data in memory.

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

4 Answers   Oracle,

---

What is rollback trigger in a trigger?

1 Answers  

---

What mandatory options are required for bcp command utility?

1 Answers  

---

What is open client in sybase?

1 Answers  

---

What is asa in sybase?

1 Answers  

---

Why am I running out of locks on the replicate side in sybase ?

1 Answers  

---

Is data insertion is fast in SYBASE IQ if we have more indexes on a table?

3 Answers   FIC,

---

what is directio?

2 Answers  

---

How do I set ts role in order to run certain dbccs?

1 Answers  

---

Explain timestemp datatype in sybase.

1 Answers  

---

State some of the products of sybase?

1 Answers  

---

Explain update statistics.

1 Answers  

---