How to find the common problems from the trace file
1. didn't use the bind variableA number of very similar statements that execute only once (Executions = 1)2. Ratio between logical IOs and processed rows is big (greater than 1000)Normally this is evidence of an inferior execution plan and could also indicate a big number of throwaways due to po...