Interested to Buy Any Domain ? << Click Here >> for more details...
What is a clustering index?
- 2 Answers
- 5455 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 is the difference between drop table and delete table?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
What is an alias?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
What is bind package and plan in db2?
how do you resolve -805?
What is explain plan in db2?
Give some example of statistics collected during RUNSTATS?
What is a cursor?
Explain the contents that are a part of dclgen.
Could anyone clearly explain the diference between sub query and correlated sub query?
COBOL 
