C Books Guide and List
C++ Books Guide and List
Best Java Books

3,749 questions

4,049 answers

114 comments

10,705 users

What is Index?

0 votes
11 views
asked Mar 8, 2014 by kelly johnes Advisor (6,330 points)

1 Answer

0 votes
An index is a physical structure containing pointers to the data. Indices are created in an existing table to locate rows more quickly and efficiently. It is possible to create an index on one or more columns of a table, and each index is given a name. The users cannot see the indexes; they are just used to speed up queries. Effective indexes are one of the best ways to improve performance in a database application. A table scan happens when there is no index available to help a query. In a table scan SQL Server examines every row in the table to satisfy the query results. Table scans are sometimes unavoidable, but on large tables, scans have a terrific impact on performance.
 
answered Mar 8, 2014 by smith Geek (15,340 points)

Related questions

0 votes
1 answer 20 views
0 votes
1 answer 26 views
0 votes
1 answer 25 views
0 votes
1 answer 11 views
11 views asked Mar 8, 2014 by smith Geek (15,340 points)
0 votes
1 answer 16 views
16 views asked Mar 7, 2014 by smith Geek (15,340 points)
...