i am relatively new to database & dont know eacatly when an index should be created... i've read that indexes at the wrong places will decrease performance. Can someone help me with when an index should be created?
check outhttp://www.sql-server-performance.com/optimizing_indexes.asp as well as SQL Server Books online
If you are a beginner, the website is a good place to start. At first, you may find all of the information here a little overwhelming, but once you get some experience, it will all begin to make sense. See the website's home page (toward the bottom) for lots of info on indexes. Rortloff's suggested url is a very good start. ------------------ Brad M. McGehee Webmaster SQL-Server-Performance.Com