Re: programmatically updating table statistics

On Dec 7, 6:51 am, Wisser <RalfWis..._at_gmx.de> wrote:
> Hi,
>
> is it possible to programmatically update table statistics by
> executing SQL-statements via Jdbc-driver?
> My DB-application fills an initially empty table with a huge number of
> rows and I try to speed-up the application by keeping the table-
> statistics uptodate.
>
> Thanks,
> Ralf

Jonathan Lewis talks about this approach in his latest book. It's not an easy read exactly but worth working through.

Yes it is possible ... usually something you want to try to avoid if you can. That's the short response.

One possible approach is avoiding having stats for the table and using dynamic sampling. Do you use bind variables in your applications so your statements stay in the shared pool? Received on Fri Dec 07 2007 - 17:03:03 CST