Answer / Mohit Tomar

Index covering offers several benefits in Sybase:
1. Faster Query Execution: Because fewer disk reads are required, queries execute faster.
2. Reduced I/O Load: Less data needs to be read from disk, reducing the overall I/O load on the system.
3. Improved Concurrency: With less data being read from disk, other users can access the database more easily.

What is cis and how can I use it?

1 Answers  

---

How to pad with leading zeros an int or smallint in sybase?

1 Answers  

---

What causes re-resolution of a stored procedure in sybase?

1 Answers  

---

How would you list objects in sybase?

1 Answers  

---

What will cause the size of a stored procedure to grow in sybase?

1 Answers  

---

Can I use a named pipe to bcp/dump data out or in in sybase?

1 Answers  

---

What is cmaxpktsz good for in sybase?

1 Answers  

---

What is this tds protocol in sybase?

1 Answers  

---

What is the use of 'with check' option in views?

1 Answers  

---

Explain about sybase 365?

1 Answers  

---

Explain asa, asa ultralite.

1 Answers  

---

How do I capture a process s sql in sybase?

1 Answers  

---