<p>When you have a query or stored procedure that needs performance tuning, what are some of the first things you try?</p>

Look at the where clause - verify use of indexes / verify nothing silly is being done
```
```
where SomeComplicatedFunctionOf(table.Column) = @param --silly
```
```