What is an index?

Answer Posted / sanjay mukati

Index is a such type of mechanism in which records are
searched and fetched efficiently and fastly in a table. It
is physical address of data.

Two type of index :
A. Cluster Index
B. Noncluster Index

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you rename a table in sql server?

490


What is change data capture (cdc) feature?

592


What is the purpose of grouping data in a report?

544


What is checkpoint process in the sql server?

551


What is query optimization process?

520






Mention the different types of replication in sql server.

561


What is the new security features added in sql server 2014? : sql server security

567


When I delete any data from a table, does the sql server reduce the size of that table?

587


What is the stuff?

529


How many types of objects are there?

508


Explain filtered indexes?

560


Can I save my report as html, excel or word? : sql server management studio

548


What are the diifferences between the ms sql server vs mysql?

657


Can we use where clause in union?

597


How do you delete duplicate rows in sql server?

508