Interested to Buy Any Domain ? << Click Here >> for more details...
What is a clustering index?
- 2 Answers
- 5524 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 will the DB2 optimizer do?
can any body explain about plan and pakage in detail....
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
What are data types?
Can you Average the Characters ?
What is a data page?
The only place of VSAM KSDS in DB2 is?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What r the comman abends in db2, jcl and cobol???????
When DB2 connection fails, will online program work or give errors.
What is query for your birthday date should be in hours,minute and seconds format?
Who uses db2?
COBOL 
