What are the type of Indexes? which one is best, why?

Answer Posted / s. sundar

1. Clustered Index
2. Non-Clustered Index

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of passing name-value pairs as parameters?

832


what are the important architecture components of SSRS?

112


Are semicolons required at the end of sql statements in sql server 2005?

735


Mention the command used to rename the database.

725


What is the security model used in sql server 2005?

694






How to create prepared statements using odbc_prepare()?

776


What is difference between stored procedure and user defined function?

728


What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

805


How to create hyperlink from returned sql query ?

823


explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

833


How the authentication mode can be changed?

846


What is the difference between join and inner join?

722


What are null values in ms sql server?

754


Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

755


What is the difference between functions and stored procedures?

793