What is a clustering index?
- 2 Answers
- 4711 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 |
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
List out the three types of page locks that can be held.
What are foreign keys?
Define declaration generator (dclgen).
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
How to rename a table in DB2 ?
how to copy the host variables from ps file into cobol program other than include statement
What is a DB2 catalog?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How does coalesce work?
How to solve S0C7 abend with out using DISPlay in 10 mins?
COBOL 
