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

Answer Posted / a.ganesh

not only two type, more type of indexes there
such as Clustered Index with Primary And Index with Uniqu

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to get the definition of a user defined function back?

633


Is port 1433 secure?

609


you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

594


What are different types of collation sensitivity?

596


What is the process of indexing?

581






What do you mean by authentication modes in sql server?

674


Write the syntax for stuff function in an sql server?

600


Explain how would you store your query in an SSRS report or a Database server?

92


Explain transaction isolation levels in sql server?

612


What happens if null values are involved in bitwise operations?

667


How to convert a unicode strings to non-unicode strings?

630


What is difference between Datepart() and Datename() in SqlServer?

779


Why is sql server log file full?

614


Why use update_statistics command in sql server?

626


Explain different backup plans?

597