search
Login

Categories


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

3.8k questions

4k answers

117 comments

10.7k users

0 votes
14 views
asked Advisor 6.3k points 5 21 29

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 Geek 15.3k points 14 39 58

Related questions

0 votes
1 answer 21 views
0 votes
1 answer 29 views
0 votes
1 answer 29 views
0 votes
1 answer 12 views
12 views
asked smith Geek 15.3k points 14 39 58
0 votes
1 answer 18 views
18 views
asked smith Geek 15.3k points 14 39 58
...