Answer / pawan

Clustered indexes can be created to order the rows in the
table in the same physical order as the desired result
set.Clustered indexes allow for a more linear access
pattern to data pages and more effective prefetching, and
help avoid sorts.Only one cluster index can be created on
table.

Answer / s

Clustering Index is an index defined with the CLUSTER
keyword and determines where the row should be inserted to
maintain the clustering sequene

insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

3 Answers   Syntel,

---

how to resolve -818 error. how to see timestamp token in load module and plan

4 Answers   IBM,

---

wht are the restrictions for union ?

2 Answers   CTS,

---

wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

What os does db2 run on?

0 Answers  

---

How can you do the explain of a dynamic sql statement?

0 Answers  

---

what is the name of the default db2 catalog database?

3 Answers   IBM,

---

can we drop column from a table

7 Answers   INDUS,

---

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

---

What are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,

---

What is correlated subquery?

1 Answers  

---