1. Try to use column names instead of * in SELECT statement
2. Try to avoid IN clause
3. Try to avoid Casting, Data type conversion in WHERE clause
4. whenever joining with table, try to order the columns ( in ON Clause ) in same order of Indexed columns
5. When handling huge volume of table, approach Temporary table ( Session table)
6. Instead of using Sub query, try to use common table expression ( CTE )
7. In WHERE clause, try to order the columns in same order of Indexed columns
8. Try to avoid CURSOR, In case if it is require go with read only CURSOR
Comments
Post a Comment