What is the difference between clustered and non-clustered indices? ...and why do you use a clustered index?

  • Interview Candidate
  • 6
  • 6091

Showing Answers 1 - 6 of 6 Answers

Tushar

  • Oct 5th, 2007
 

Clustered Index creates physical order on the table based on the defination given. You can only have one clustered index.

  Was this answer useful?  Yes

seemabuchhada

  • Mar 13th, 2014
 

One table can only have one clustered Index (When we create primary key on table,oracle automatically creates Clustered index on that column) but It can have many non clustered index, approximately 250

  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