adspace


What is the difference between clustered and non-clustered index? : sql server DBA

Answer Posted / Akhand Pratap Kaushal

A clustered index determines the physical order of data in a table, and there can be only one clustered index per table. A non-clustered index is a separate structure that contains the indexed columns' values and a reference to the corresponding row location in the table. Non-clustered indices support multiple indexes per table.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2184


what is the last version,the release date of that version and fix pack of ibm db2 udb?

2058


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2717