What is the basic difference between clustered and a
non-clustered index?

Answer Posted / bhai(prakash.g)

clustered index is only one clustered index per table.
non clustered index is more than one in table.

Is This Answer Correct ?    10 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens if null values are involved in string operations?

552


How to optimize stored procedures in sql server?

619


How to use linked server?

588


What area unit the various kinds of info compression introduced in sql server 2008?

564


Explain linked server in sql?

691






New concepts of sql server 2005 use in your project.

1910


Explain the commands in sql server?

546


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

555


Write a program to fetch first 10 records from a file?

600


what's the difference between a primary key and a unique key? : Sql server database administration

497


Explain difference between control flow and data flow?

526


How do I view a procedure in sql server?

533


What is repeatable read?

540


What is a collation in ms sql server?

545


What is checkpoint in sql server?

616