How many clustering indexes can be defined for a table?

Answer Posted / s

Only one clustering index can be defined.

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is query_cache_limit?

791


What is catalog database in db2?

894


What does reorg do in db2?

816


Define predicate?

910


How does db2 sample database connect?

813


What is a bind in db2?

801


Which command is used to connect to a database in DB2 ? Give the Syntax.

876


What is dclgen (declaration generator)?

850


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2192


On which levels locks can be applied?

904


Explain about mirror activator disk mirroring?

803


What are the full forms of spufi and dclgen and why are they used?

882


What is dbrm? When it will be created?

807


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1035


How many types of page locks can be held in db2?

850