Re: programmatically updating table statistics

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Fri, 07 Dec 2007 14:05:48 +0100
Message-ID: <4759452C.1090801@gmail.com>

Wisser schrieb:
> 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

You are not allowed to execute sql directly over data dictionary, but there is well documented API for that purpose. http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_stats.htm#CIHEGDBJ

Best regards

Maxim Received on Fri Dec 07 2007 - 07:05:48 CST