What is an index?

Answer Posted / shrikant kalwade

Index means we create unique id to record in to the table.

primary key is example of index; using proper index we
search perticular record from database fast and accurate.

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use transact-sql statements to access the database engine?

537


Give the query of getting last two records from the table in SQL SERVER?

535


What happens to a trigger with multiple affected rows?

526


What is conditional split?

538


What is the purpose of sql profiler in sql server?

509






What is the difference between a local and a global temporary table?

618


How to use copy and concatenate commands in SQL?

597


How do I get Report Builder to generate a parameter that can be set by users viewing the report?

100


You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

482


What is partition, how will you implement it? : sql server analysis services, ssas

597


What is dbcc?

730


What is importing utility?

544


Explain what is use of dbcc commands?

507


What is dbcc command in sql server?

581


Define right outer join in sql server joins?

513