Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: 10g optimizer and dynamic sampling
p.santos000_at_gmail.com wrote:
> Well that's a good point, but here is the difficult thing about this
> system. Our customers
> upload data anytime they want at any point of the day. So in the
> morning COL1='X' could
> return 100 rows, but the same query in the evenning could yield a
> million rows.
>
> Most of the queries executed on our system take anywhere from 5 minutes
> to 30-45 minutes, so a couple of extra seconds is for the sampling is
> insignificant.
>
> -peter
>
Peter, if that is Oracle 9i you can set tables to "MONITORING", in which case DBA_TAB_MODIFICATIONS will be populated and statistics scanned dynamically only for the tables with more then 10% of changed rows.
-- Mladen Gogala http://www.mgogala.comReceived on Fri Jun 02 2006 - 14:37:31 CDT
![]() |
![]() |