Answer / swapnil

USING AN INDEX WE CAN ACCESS THE KEY VERY FAST
ON PRIMARY KEY YOU CREATE AN INDEX.

Answer / dilon

index are nothing but primary key in the table...
ex:create table emp(eno numeric(4) not null primary key,
ename char(10) not null,
elocation char(10) not null)
in this example employee number eno is the primary key it is
called as index...

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,

---

Is ibm db2 free?

0 Answers  

---

How would you print the output of an SQL statement from SPUFI?

2 Answers  

---

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

0 Answers  

---

What is db2 look?

0 Answers  

---

---

What is the difference between db2 and oracle?

0 Answers  

---

What is a buffer pool?

2 Answers  

---

What is COPY PENDING status?

6 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 is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

---

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers   IBM,

---

What is DB2 (IBM Database 2)?

3 Answers  

---