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
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