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 |
Where is adodb dll located?
Describe the command object and its method.
What is the hierarchy of data in databases?
Differnce between Stored procedure and user defined functions?
17 Answers Microsoft, Symphony,
How do you update a dataset in ado.net?
What is ado or jdbc?
Define data access layer?
If a table contains 20000 records. In a page at each time 100 records to be displayed.
What are the two fundamental objects in ADO.NET?
Difference between OLEDB Provider and SqlClient ?
What is Pooling? what is data pooling? what is sql pooling?
What is the key feature of ADO.NET compared to ADO ?