sql optimization

[hariom sharma]

Hi

i would like to have suggestions for optimizing select query so that
it runs faster.Besides using indexes on key columns what are other
precautions and measure to achieve it?