cybersavvy

 Profile Answers by cybersavvy 

• Feb 19th, 2009

 

1.  Use many WHERE clauses in the SELECT  statments.
2.  Select only those fields which you really require.
3.  Joins are expensive in terms of time. Join the tables using related fields manly indexed fields.
4.  Don't use unused tables.

bonagirdipti

 Profile Answers by bonagirdipti 

• Feb 17th, 2010

 

To expect improvemnt in stored procedure performance, pl keep following points in mind :-

1. Please don't use many subqueries.
2. Don't use cursor, instead of it, use temp. table in the looping.
3. Drop/release objects whichever created and used in that proc block.

These are few additiond from my side..

hiteshvyas

 Profile Answers by hiteshvyas 

• Apr 21st, 2010

 

Use the following steps:
1) Dont use temporary tables instead use CTE or table Variable
2) Use Inner Join instead of Sub Queries.
3) Check indexs in tables used
4) Instead of Select * from use select column1,column2.
5) Use Query Execution plan to check time taken for query to get executed.

These are few things that can be followed for better performance