Difference between Cluster and Non-cluster index?
Answer Posted / vikram kumar
The biggest difference between a clustered index and a non-
clustered index is that when you use a clustered index, the
section of the table that comprises the index has its data
pages linked differently from those data pages comprising a
non-clustered index.
In SQL Server 2005 you'll probably hear the term "heap or B-
Tree."
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How can we migrate from SQL server to SQL Azure?
What action plan is preferred if sql server is not responding?
How to modify an existing user defined function?
Define cross join in sql server joins?
How can sql server instances be hidden?
What is rs.exe utility?
How do I start sql server 2016?
what is the sql equivaent of the dataset relation object ?
What is a select query statement in ms sql server?
List some advantages and disadvantages of stored procedure?
What are different types of database indexes?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What are sparse columns?
List all the types of user-defined functions?
Give an example of SQL injection attack ?