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

How to create function without parameter in sql server?

555


In what sequence sql statement is processed?

579


What is difference between line feed ( ) and carriage return ( )?

515


What is the use of sign function?

555


Do you know what are the steps to process a single select statement?

528






Can an automatic recovery be initiated by a user?

549


what are isolation levels? : Sql server database administration

493


What does executeupdate return?

533


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

1433


Explain transaction server explicit transaction?

501


How do I create a partition table in sql server?

484


What different steps will a sql server developer take to secure sql server?

494


What is query parameter in ssrs?

118


Does a sql server 2005 select statement require a from?

568


What are the different types of sql server replication? : sql server replication

621