Answer Posted / vikram
Clustered index hold data at the leaf node.
non clustered hold data location (pointer) at the leaf node.
when we create primary key Clustered index automatically
created
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
What is the difference between clustered and a non-clustered index?
What is SubQuery in SQL Server 2008
Can we hide the definition of a stored procedure from a use?
How do I view a stored procedure in sql server?
How to execute stored procedure in select statement sql server?
Why variables called the most powerful component of ssis?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
Why truncate is ddl command?
What are the two authentication modes in sql server?
What is recompile sql server?
How retrieve field names from the table in SQL through JAVA code?
How do I find query history in sql server?
What is the filtered index?
What is normalization of database? What are its benefits?