programmatically updating table statistics

[Ralf]

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

[Mark A]

"Ralf" <Ra********@gmx.dewrote in message
news:78**********************************@w34g2000 hsg.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.

[Ralf]

On 7 Dez., 15:34, "Mark A" <[e-mail]:

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