Re: slow info retrieval in TOAD

From: spencer <spencerp_at_swbell.net>
Date: 2000/06/25
Message-ID: <pDz55.89$UA3.95830@nnrp3.sbc.net>#1/1

under the Trace menu option, click on the option to display sql to a window, or spool it to a file... the window display gets very annoying after a while, but it will show you the SQL that TOAD is using.

"Steve Salvemini" <steve.salvemini_at_adelaide.edu.au> wrote in message news:3956B76B.C5675AD6_at_adelaide.edu.au...
> Has anyone got some ideas on how to determine what a qery in
the Schema
> Browser is doing in Toad.
>
> When I retrieve index information it takes far too long. I
expect an
> index mod on a system table would speed it up, but I don't
know what the
> query is that it runs to get its index information. (also the
script
> creation tab is slow, maybe also dure the the slow index
query)
>
> Is there a option in toad to see what sql it runs internally,
perhaps
> through the query optimer or tracing tools?
>
Received on Sun Jun 25 2000 - 00:00:00 CDT