Three operations performed on a production database that can benefit from optimal performance include:
Generally, these operations do not need to be optimized. However, in situations where performance is critical, techniques can be used to fine-tune performance.