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.
To turn off the output, use: dbcc traceoff (3604, 302).
Ex. Nomura personnel.
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
> 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,