adspace


What is an index?

Answer Posted / sovan guha

An index is a physical structure containing pointer to the
data.Index are created in an existing table to locate rows
more efficiently and quickly.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain “row_number()” in sql server with an example?

1086


What is clustered index

1093


what is the Ticketing tool used in Wipro technologies at Bangalore...???

8237


How can we solve concurrency problems?

1129


Disadvantages of the indexes?

1230


Why we use the openxml clause?

1088


How to convert numeric expression data types using the cast() function?

1157


What are wait types?

1261


If any stored procedure is encrypted, then can we see its definition in activity monitor?

1081


How to remove duplicate rows from table except one?

1096


What is self contained sub query?

1147


Why and when do stored procedure recompile?

1075


What are different types of constraints?

1007


What is a coalesce function?

1292


Can you index views?

958