Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Darren Sany" <dsany at iname dot com>
Subject: Re: Sybase Query Analysis
Date: Apr 7 1999 1:58PM

Two main options are available to you.
Firstly, in isql use "set showplan on" followed by "set noexec on" and then
your query.  See on-line sybooks for description of these set commands in
the Performance and Tuning Section.  In Nomura you would have to "up"
sybooks in your unix session first and then simply type sybooks to bring up
the on-line documentation.

Secondly a more elaborate details of how an index has been chosen for your
query use the following command from an isql batch followed by the query or
stored procedure in question.

dbcc traceon (3604, 302)

Notes: 3604 - Directs trace output to the client rather than to the error
302 - Prints trace information on index selection.

your query...

To turn off the output, use: dbcc traceoff (3604, 302).

Darren Sany
Ex. Nomura personnel.

-----Original Message-----
To: SybPerl Discussion List 
Date: 07 April 1999 09:31
Subject: Sybase Query Analysis

>Is there a utility to get the current sybase sessions and the SQL queries
> are being run at the current time.
>I've used informix before and liked the ability to tune queries that were
> running on an instance (probably behind a blackbox application, where i
> read the source.... and hence can't change the set explain on line...)
>what I'd like to do is get the queries which take ages to run and tune
these by
> running them with the output of the optimiser being dumped...create
> indexes...and the query runs faster....
>Have any of you any ideas on how i can acomplish this???
>Many thanks in advance,
>Gavin McNay