What is a clustering index?
- 2 Answers
- 4939 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 |
How to fetch the last row from the table in SQL (db2)?
when does the SQL statement gets executed when you use cursor in the application programming ?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
What are iseries servers?
What are the different types of base tables?
What's the difference between DB2 active log and archive log? Thanks a lot...
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
What is copy book?
What is query for your birthday date should be in hours,minute and seconds format?
What is a db2 package?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
How do I optimize a query in db2?
COBOL 
