Is it possible to optimise an insert statement?
I am running query logging to find unoptimised sql statements in my application to try and find bottlenecks.
In the log that gets built, insert statements show up as unoptimised.
Is it possible to optimise an insert statement or should I ignore these when viewing the log?
Also I get unoptimised entries for stored procedure execute statements. Do these always show as unoptimised or is it telling me that a statement inside the SP is unoptimised?