Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
francis_lemos
Starting Member
4 Posts |
 Posted - 2011-12-27 : 14:59:44
|
| Hithis is my first post since I'm a newcomer to SQL Server 2008 forums. I'm wondering if one can see the content of an index such as that of table.KR |
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2011-12-27 : 15:22:22
|
quote:
Originally posted by francis_lemos
Hithis is my first post since I'm a newcomer to SQL Server 2008 forums. I'm wondering if one can see the content of an index such as that of table.KR
What you should really be asking is "What is an index" and look it up. This web link will help you and also answers your question about how to "see the content of an index". The answer to that question is yes since indexes are built off of table columns..[url]http://en.wikipedia.org/wiki/Index_(database)[/url]If you meant something else by your question plz clarify. |
 |
|
|
francis_lemos
Starting Member
4 Posts |
Posted - 2011-12-27 : 15:27:32
|
| I know whars an index but is it possible to query one to find out its content? to actualy look at its content to see if its fragmented for instance? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-12-27 : 16:21:02
|
| Contents of index = contents of specific columns from table. There's a row in the index for each row in the table, so if you have an index on the column Person, the contents of that index is the contents of the column Person from the table.--Gail ShawSQL Server MVP |
|
|
|
francis_lemos
Starting Member
4 Posts |
Posted - 2011-12-27 : 18:18:18
|
| thx Tara, Gail very enlightning |
|
|
|
|
|
|
Indexes