Tuning an expensive SQL statement on SAP

Tuning an expensive SQL statement

Create/change an index

Check if Auto update statistics is on

Understand the DB Optimizer

 Rewrite poor coding

 Use optimizer hints