what is clustered index?why is it created?
Answer Posted / kuldeep kumawat
clustered index make physical table of the underline base table like (PhonBook,Discretionary)
and
Non clustered index is a reference table key of base table.
nonclusterd index has reference key to point a main table record
(like our not book we have index at first page and page number )
Example blow here ..
topics page no
class 20
object 30
asp.net 300
practices Example 330
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of ado.net?
What is a non query?
What is the difference between executenonquery () and executescalar ()?
How to bind the controls(best practice) comboboxes to the data in the dataset?
How can we perform transactions in .net?
What we do with the object of ado.net dataset after using it?
What is difference in record set and dataset?
What is typed dataset ?
What is the difference between an ADO.NET Dataset and an ADO Recordset?
What is datasource in ado.net?
What is full form of ado?
What is ado.net in vb net?
What are typed and untyped dataset?
What are the advantages of using datalist?
What is difference between sqldatareader and sqldataadapter?