Clusterd a non-clustered index

just checked everyones answer and they are all right

but the question is what filed is been clustered index (CI) and what has the non-cluster index (NCI)

 

generally the CI is on a internal key like  a surrogate key which help in a scenario like Master, detail table, something like an INNER JOIN but the NCI key is generally on natural key or business keys like your SIN number or your student ID, what i am trying to say is tha the NCI will be maily used in the WHERE clause of your views if needed

 

Good luck 

Clustered is the fast process because in this case data stored physically in a same table.

 

Where in case of Non - Clustered Table, data stored in heap and related point is stored in the Table.

Hello

 

Well there are so many great difference avilable 

 

You just need to go through few article :

 

https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described 

 

https://www.c-sharpcorner.com/blogs/differences-between-clustered-index-and-nonclustered-index1

 

https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes-in-sql-server/

 

https://stackoverflow.com/questions/91688/what-are-the-differences-between-a-clustered-and-a-non-clustered-index

 

Try to read and understand concept , your doubt will be solved for sure

 

Thanks