Answer / Gulshan Kumar

The DB2 Optimizer is a key component that determines the most efficient way to execute SQL statements by choosing the best access path and query plan. It helps in improving query performance by reducing I/O operations, CPU usage, and network traffic.

what is a collection?

2 Answers  

---

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1 Answers  

---

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  

---

What parameters are used to control the free space in DB2?

1 Answers  

---

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

---

How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,

---

What is index in db2?

1 Answers  

---

How to compare data between two tables in db2?

1 Answers  

---

What does sqlcabc has?

1 Answers  

---

what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,

---

what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,

---

How do I create a view in db2?

1 Answers  

---