What are indexes? When do you need to create Indexes?

Answer Posted / rajeev

Index is used for fast searching and batter performance.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is database replication?

574


What is the difference between having clause and where clause in sql server?

566


What is in place upgrade in sql server?

519


Is foreign key a primary key?

507


What is the status of services on passive node for failover cluster in sql server? : sql server database administration

629






How do I port a number to sql server?

500


What is parameterized reports in ssrs ?

105


What is difference between after and before?

499


What do you understand by mirroring and mention the advantages of the mirroring?

577


What is the use of sign function?

555


Why people hate cursor?

725


What language is sql server written in?

527


Explain transaction server consistency?

518


Determine when an index is appropriate?

554


Is mysql better than sql server?

536