define clustering index.
- 1 Answers
- 1093 Views
- I also Faced
- E-Mail Answers
Answer / Sandip Kumar Tiwari
A clustering index in DB2 organizes the table data based on the value of one or more columns. This type of index can significantly improve performance for queries that frequently filter, sort, or join data using the clustered columns.
| Is This Answer Correct ? | 0 Yes | 0 No |
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
How can you quickly find out the number of rows updated after an update statement?
What is alias in db2?
How to take backup of table in db2?
What is db2 plan table?
What is the reason behind not using select * in embedded sql programs?
Can any one tell me about Restart logic in DB2.
How does cobol compile db2 program?
Are views updatable ?
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
What is db2 purescale?
what is the sqlcode -501
COBOL 
