RE: performance in 10g

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


Other related posts: