Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> poor toad performance

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@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 Wed Oct 25 2000 - 21:29:03 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US