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 to transfer a table from one schema to another?

562


New concepts of sql server 2005 use in your project.

1914


What is implicit mode in sql server?

568


How to read data in a table with "select" statements?

565


What is the most common trace flags used with sql server?

524






Describe how to use linked server?

551


What is inner join in sql server joins?

551


Write a SQL query to make a column as unique?

632


What is the difference between mysql and mysqli?

587


What is use of except clause? How it differs from not in clause?

606


What is user defined datatypes and when you should go for them?

591


How to use copy and concatenate commands in SQL?

603


What do you mean by an execution plan?

570


Difference between uniqe index and uniqe constraint?

556


Describe in brief authentication modes in sql server.

571