Re: programmatically updating table statistics

From: Wisser <RalfWisser_at_gmx.de>
Date: Mon, 10 Dec 2007 02:06:16 -0800 (PST)
Message-ID: <cf110ba5-2d23-49ab-b9bb-0ff280f7ee5f@18g2000hsf.googlegroups.com>

On 8 Dez., 00:03, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> On Dec 7, 6:51 am, Wisser <RalfWis..._at_gmx.de> wrote:
>
> Jonathan Lewis talks about this approach in his latest book. It's not
> an easy read exactly but worth working through.
>
> Yes it is possible ... usually something you want to try to avoid if
> you can. That's the short response.

Sorry for not asking precisely enough. I never thought about manipulating the statistics directly, but by calling stored procedures.

> One possible approach is avoiding having stats for the table and using
> dynamic sampling. Do you use bind variables in your applications so
> your statements stay in the shared pool?

No, I don't use bind variables. What is "dynamic sampling". Is it possible to tell the DB that a table has "voilatile cardinalty", as one can do with db2?

Best regards,
Ralf Received on Mon Dec 10 2007 - 04:06:16 CST