Use the tutorials in this section to learn how to use the Database Tracing Wizard to view execution times for statements, and how to identify statements that appear to run slowly.
A slow statement occurs when the database server takes a long time to process the statement. Long processing times can be the result of several issues such as an improperly designed database, poor use of indexes, index and table fragmentation, a small cache size, and so on. A statement may also run slowly because it is not well formed, or does use more efficient shortcuts to achieve results.
This tutorial does not show you how to rewrite slow statements, since each statement can have special requirements. However, the tutorial does show you where to look for execution times, and how to compare execution times when rewriting queries using alternate syntax.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|