poor toad performance
From: Steve Salvemini <steve.salvemini_at_adelaide.edu.au>
Date: Thu, 26 Oct 2000 11:59:03 +0930
Message-ID: <39F796EF.64BCB4B0_at_adelaide.edu.au>
Date: Thu, 26 Oct 2000 11:59:03 +0930
Message-ID: <39F796EF.64BCB4B0_at_adelaide.edu.au>
It seems performance problems in Toad running on Oracle 8.04 (I know it's a very old version) is that it runs really badly using the COST based optimiser.
Either
Change the database default from CHOOSE/COST to RULE based
or:-
Change the default optimiser each time you log into Toad, then all
queries, including internal Toad queries will then run using RULE, and
run a LOT quicker
Received on Thu Oct 26 2000 - 04:29:03 CEST