Answer / Shiv Prasad Shukla

Update Statistics in Sybase is a database maintenance task that updates the statistics for a specific table or index. These statistics are used by the query optimizer to make informed decisions about which execution plan to use for a given query. Over time, as data in the tables changes, the statistics can become stale and misleading, leading to suboptimal query performance. Updating statistics helps ensure that the query optimizer has up-to-date information when choosing an execution plan.

Explain tds (tabular data streams).

1 Answers  

---

what is update statistics in sybase?

1 Answers  

---

How to swap a db device with another?

1 Answers  

---

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

1 Answers  

---

We have lost the sa password, what can we do?

1 Answers  

---

List some of the products of sybase.

1 Answers  

---

Explain index covering? List its merits.

1 Answers  

---

You need to remove the affected rows and dashes. How would you do that?

1 Answers  

---

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

1 Answers  

---

How to divide by zero and nulls in sybase?

1 Answers  

---

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

1 Answers  

---

When should I execute an sp_recompile in sybase?

1 Answers  

---