Interested to Buy Any Domain ? << Click Here >> for more details...
What is a clustering index?
- 2 Answers
- 5428 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 |
When is the access path determined for dynamic SQL?
What is Reorg Recovery? when will you run it?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What is meant by explain?
What is drop table?
If I have a view which is a join of two or more tables, can this view be updateable?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
how to copy the host variables from ps file into cobol program other than include statement
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
How do you filter out the rows retrieved from a Db2 table ?
Which command is used to remove all rows from a table?
COBOL 
