Indexing in sql 2008

Question

hi all can anybody tell how do i do indexing to improve performance(with small ex plz)

Rajeesh Menoth · Answer

Hi Indexes An index can be created in a table to find data more quickly and efficiently. Refer the following article : http://www.w3schools.com/sql/sql_create_index.asp http://www.codeproject.com/Articles/234399/Database-performance-optimization-part-Indexing http://www.tutorialspoint.com/sql/sql-indexes.htm

Vinay Singh · Answer

Hi have a look of the link http://www.codeproject.com/Articles/39006/Overview-of-SQL-Server-Table-Indexing-Pa