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
How can we add/remove row's in "datatable" object of "dataset"?
What is the functionality of data provider in ado.net?
Which namespaces are used for data access?
Which control of the BindingNavigator returns the current position within the data source?
What is a control toolbox?
What is an example of ordinal data?
What is oledb driver?
Explain what is datagrid with an example?
What do you know about ado.net's methods?
What is the significance of CommandBehavior.CloseConnection ?
What are the data providers in ADO.NET framework?
List all the steps in order, to access a database through ado.net?
What are the major challenges in accessing data from a database?
Define data access layer?
What is the difference between DataReader and DataSet in ADO.NET?