What is a clustered index?
- 1 Answers
- 12575 Views
- I also Faced
- E-Mail Answers
Answer / pradeep
a clustered index is a indexin which both index and data
rows will be arranged in some particular sequence
datarows will be arranged based on the index in leaf pages
| Is This Answer Correct ? | 10 Yes | 3 No |
Describe the elements of the SELECT query syntax?
how can u nderstand the sql stmts executed successfully or not ?
What happens to a cursor after a commit?
Who uses db2?
What is a db2 table?
How can you find out the # of rows updated after an update statement?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
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
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
What is meant by a unit of recovery?
How do you check for a null value in a db2 column?
pls tell me abt the normalization five types....
COBOL 
