A list of tips for optimising a Sybase query that is performing poorly.