By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,729 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

programmatically updating table statistics

P: n/a
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
Dec 7 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/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.
Dec 7 '07 #2

P: n/a
On 7 Dez., 15:34, "Mark A" <nob...@nowhere.comwrote:
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
Dec 7 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.