SEO

#1 (**permalink**) 02-27-2008, 01:09 PM

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 up-to-date.

Thanks,
Ralf

#2 (**permalink**) 02-27-2008, 01:09 PM

"Ralf" <RalfWisser@gmx.de> wrote in message
news:785b7c28-6563-4287-91f8-17095d5cd5ab@w34g2000hsg.googlegroups.com...
> 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 up-to-date.
>
> Thanks,
> Ralf

You can use the admin stored procedure to submit a runstats.

Better yet is to start off with tables defined as volatile (see alter
table). I suspect this will solve your problem without worrying about
immediate runstats.

#3 (**permalink**) 02-27-2008, 01:09 PM

On 7 Dez., 15:34, "Mark A" <nob...@nowhere.com> wrote:
> Better yet is to start off with tables defined as volatile (see alter
> table). I suspect this will solve your problem without worrying about
> immediate runstats.

defining the table as volatile works well, thank you.

Ralf

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

programmatically updating table statistics