This tutorial assumes you have created the test database. If you have not, see Lesson 1: Creating the test database.
You can copy and paste the SQL statements in this tutorial into Interactive SQL.
Start Sybase Central and connect to the test database app_profiling - DBA with the user ID DBA and the password sql.
If you are unfamiliar with starting Sybase Central and connecting to a database, see Connect to a local database.
In the left pane, select the app_profiling - DBA database, and then choose File » Open Interactive SQL.
Interactive SQL starts and connects to the app_profiling - DBA database.
In Interactive SQL, run the following SQL statements:
Create a table:
CREATE TABLE table1 ( Count INT ); |
Create a baseline procedure:
CREATE PROCEDURE baseline( ) BEGIN INSERT table1 SELECT COUNT (*) FROM rowgenerator r1, rowgenerator r2, rowgenerator r3 WHERE r3.row_num < 5; END; |
Commit the changes you made to the database:
COMMIT; |
Close Interactive SQL.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |