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 are the advantages and drawbacks of using ado.net?
What happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?
Is entity framework better than ado.net?
What is microsoft ado?
Difference between function and trigger?
Do we use stored procedure in ADO.Net?
What is ole in excel?
Explain the overview of ado.net architecture?
How to fetch the last inserted record in a particular table?
10 Answers CarrizalSoft Technologies, Microsoft,
What are all components of ADO.Net data provider?
Differences between dataset.clone and dataset.copy?
What is a datagrid?
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)