programmatically updating table statistics

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ralf - 07 Dec 2007 14:19 GMT

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

Reply to this Message

Mark A - 07 Dec 2007 14:34 GMT

> Hi,
>
[quoted text clipped - 6 lines]
> 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.

Reply to this Message

Ralf - 07 Dec 2007 15:00 GMT

> 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

Reply to this Message