Re: programmatically updating table statistics

On Dec 7, 1:51 pm, 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

Just enable monitoring on the affected tables (alter table ... monitoring) and run dbms_stats.gather_schema_stats with the appriopate options (STALE comes to mind) after the deed. For dbms_stats refer to http://www.psoug.org/reference/dbms_stats.html

--
Sybrand Bakker
Senior Oracle DBA

Senior