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 does ADO.NET consists of ?
What are typed and untyped dataset?
What are the steps you will take to improve performance? Will you use dataset or datareader?
what are the two key events for the sql connection class? explain the differnce between the two.
What is connected architecture in ado.net?
What is the difference in record set and dataset?
Explain the difference in an abstract class and an interface?
If a table contains 20000 records . In a page at each time 100 records to be displayed. What are the steps u will take to improve performance? will you use dataset or datareader?
What is ado.net architecture?
Explain the difference between data reader and data set?
What is Debug.write does?
Explain the overview of ado.net architecture?
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)