Interested to Buy Any Domain ? << Click Here >> for more details...
What is a clustering index?
- 2 Answers
- 5561 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 3 Yes | 0 No |
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
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
Can we use select * statement in cobol program without giving field names ???
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
what's the best lock size that you could use when you create a tablespace?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What is the use of runstats in db2?
List some fields from sqlca?
What is ibm db2 client?
how to resolve -811 error. give clear explination
How will you delete duplicate records from a table?
what is check point and restart Logic ? why do we go for that ??
COBOL 
