Process documentationProblem Analysis Locate this document in the navigation structure

 

If the database system is taking too long to execute an SQL statement, analyze your database and, if necessary, the way SQL Optimizer is working.

Process

  1. Read the general information on troubleshooting.

    More information: Database Administration, Troubleshooting, Analyzing Database Performance

  2. You can specifically analyze the SQL statements. You use the EXPLAIN statement, for example, to find out which search strategy the SQL Optimizer is using for the SQL statements.

    More information: EXPLAIN Statement

  3. Check your data model.

More Information