Indexes and abstracts in SQL Server
Home > IT Answers > SQL Server > Indexes and abstracts in SQL Server
SQL Server Ask the Experts
2445 pts.
0
Q:
Indexes and abstracts in SQL Server
SQL Server, Indexes, Abstracts
In regards to a SQL Server, what is an index? Also, what is an abstract, and could you please explain the types of both of these items?
ASKED: Dec 29 2008  7:45 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
An index is an object in the database which contains one or more columns from a single table. The data within the index is sorted which makes it much faster to search than searching the table it self.

There are a couple of blog posts which I've made about indexes.
What’s the difference between a Scan and a Seek?
Back To Basics: Creating Indexes
Last Answered: Dec 30 2008  2:08 AM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0