RE: performance in 10g

  • From: "David Boyd" <davidb158@xxxxxxxxxxx>
  • To: Riazouddine.Rahamathullah@xxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 25 Jan 2007 09:10:15 -0500


Thanks for your quick response.  We do have the latest stats in place.


Gather the objects statistics first using DBMS_STATS which will help you
to improve the performance a lot.  Because, no RBO in oracle 10g and the
optimizer will give you the optimized plan if your db should have the
latest stats.

Search for grocery stores. Find gratitude. Turn a simple search into something more.


Other related posts: