Following are tips which will increase your SQl performance :-
3. Try to create indexes on columns that have integer values rather than character values.
4. Clustered indexes are more preferable than nonclustered, if you need to select by a range of values or you need to sort results set with GROUP BY or ORDER BY.