Interested to Buy Any Domain ? << Click Here >> for more details...
How many clustering indexes can be defined for a table?
- 2 Answers
- 7044 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mehdee
Yes Only one clustering index can be defined.And reason is
Clustered indexe is created to order the rows in the
DB2 table in the same physical order as the desired result
from the indexe. And if we do not use this option, DB2 will
come up with one to do this ordering rows.
| Is This Answer Correct ? | 3 Yes | 0 No |
can all users have the privilage to use the sql statement select * (dml)?
What is a result table?
What is the difference between drop table and delete table?
how to resolve -811
What is alias in db2?
What is cursor stability?
How to fetch the uncommited data from table ?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
What is the function of logging in the db2 database?
What is concurrency?
Which component is responsible for processing sql statements and selecting access paths?
Highlight all the advantages that are attached to a package.
COBOL 
