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 |
|
Amateur
Starting Member
2 Posts |
 Posted - 2007-02-18 : 15:48:40
|
| I'm looking for information on how to add indexes to a table in a SQL Server 2000 Database, why add them etc? Specifically, I want to add non clustered indexes to tables using Enterprise Manager. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-18 : 23:08:53
|
| Your primary source of information should be Books Online (i.e. SQL Server help files). Other than that if you want to explore the architecture of indexes, below two books I found especially useful (although bit too much for beginners):1. Inside Microsoft SQL Server 2000 - Kelan Delaney2. Microsoft SQL Server 2000 UnleashedHarsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
Adding Indexes to Table