Fastest Way to Get a Thousand Records Into The Database

Hi Ajay,

You can create non-cluster index on table column which are used in where condition or used in join.

Also Analyze an Execution Plan for you query, In Execution plan you may see which join or which part of query has maximum cost. SQL server management Studio also suggest non cluster index from execution plan.

please refer
http://www.simple-talk.com/sql/sql-training/the-sql-server-query-optimizer/

hope this will help you.