dinu78

 Profile Answers by dinu78 

• Dec 21st, 2007

 

1) First identify the current excecution plan by using showplan.

In most cases, creating and then forcing usage of the indexes result in drastic improvement.

1) Ensure that indexes(single or composite) exist for columns referred to in the where clause.

2) Avoid select(*), instead use tablename.columnname.

3) Avoid using in clause, instead use where col=value1 and col=value2 etc.