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

Answer Posted / arun pandey

Hi

1)Clustered Index
2)NON-Clustered INdex

But Clustered index is better than non-clusted
becoz the searching in clusterd is faster than non-clustered

Arun Pandey
A1Technology

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What languages bi uses to achieve the goal?

507


Difference between primary key and clustered index?

500


How can windows applications connect to sql servers via odbc?

574


How to select all columns of all rows from a table with a select statement in ms sql server?

568


What do you understand by the denormalisation?

547






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

655


Do you know query execution plan?

582


What is acid mean in sql server?

566


How can you ensure that the database and sql server based application perform well?

628


Explain few examples of RDBMS?

609


what types of replication are supported in sql server? : Sql server database administration

455


Can we write ddl in trigger?

492


What is the use of RDBMS?

583


Is the primary key column of a table an index in ms sql server?

531


Can you explain about buffer cash and log cache in sql server?

492