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


Please Help Members By Posting Answers For Below Questions

How can we add/remove row's in "datatable" object of "dataset"?

737


What is the functionality of data provider in ado.net?

659


Which namespaces are used for data access?

825


Which control of the BindingNavigator returns the current position within the data source?

905


What is a control toolbox?

673


What is an example of ordinal data?

707


What is oledb driver?

684


Explain what is datagrid with an example?

785


What do you know about ado.net's methods?

767


What is the significance of CommandBehavior.CloseConnection ?

795


What are the data providers in ADO.NET framework?

763


List all the steps in order, to access a database through ado.net?

791


What are the major challenges in accessing data from a database?

729


Define data access layer?

687


What is the difference between DataReader and DataSet in ADO.NET?

779