what is clustered index?why is it created?
Answers were Sorted based on User's Feedback
clustered index is a type oof index this is a physical
component used to to resorted the data in a table. U can use
only one clustered index for a Table.
| Is This Answer Correct ? | 14 Yes | 2 No |
Clustring is a method for storing the tables in same block
that are related.
Cluster index are used to achive this object.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / 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 |
What is Data Provider?
Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
Define atomicity?
What DataReader class do in ADO.NET ?
Difference between sqlcommand and sqlcommandbuilder?
Explain ado.net features? Benefits? Drawbacks?
What are the disadvantages of using datalist?
List all the steps in order, to access a database through ado.net?
Differences between dataset.clone and dataset.copy?
What is sqldatasource?
We all know that Dataset is purely disconnected architechure, but we also know that we can update the changes made to the dataset can be updated in the backend database. when there is no connection how does the update happedn?
6 Answers Accenture, FastStream,
How to identify the controls which can be used for binding data?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)