Use the lessons in this tutorial 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, or a small cache size. A statement may also run slowly because it is not well formed, or does not 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.
Lesson 1: Create a diagnostic tracing session
Lesson 2: Review statements processed by the database server
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |