RE: performance in 10g

From: David Boyd <davidb158_at_hotmail.com>
Date: Thu, 25 Jan 2007 09:10:15 -0500
Message-ID: <BAY101-F128C48E3E263532395B3E4EFA30@phx.gbl>

Riaz,

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

Dave

>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.
http://click4thecause.live.com/search/charity/default.aspx?source=hmemtagline_gratitude&FORM=WLMTAG

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 25 2007 - 08:10:15 CST