How many clustering indexes are passing for a table?

Showing Answers 1 - 3 of 3 Answers

saravanan

  • Jul 31st, 2005
 

only one can define at a time

pradipta

  • Feb 3rd, 2006
 

As many no of column's that table is having that many no. of indexs we can pass.

  Was this answer useful?  Yes

hemant

  • Apr 18th, 2006
 

i think only one clustering index ll be created for any table in DB2. This clustering index is created on the primary key of the table. for all other index(es) created on the table they ll be nonclustering index(es) .

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions