467,927 Members | 1,971 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,927 developers. It's quick & easy.

programmatically updating table statistics

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
  • viewed: 2111
Share:
2 Replies
"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
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.

Similar topics

1 post views Thread by Jay | last post: by
4 posts views Thread by Sky Fly | last post: by
5 posts views Thread by garydevstore | last post: by
2 posts views Thread by Lyn Duong | last post: by
11 posts views Thread by Zlatko Matiś | last post: by
5 posts views Thread by Brian McClellan | last post: by
3 posts views Thread by Otto Carl Marte | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.