Re: optimizer parameters

From: Frank <fvanbortel_at_netscape.net>
Date: Fri, 10 Oct 2003 13:38:41 +0200
Message-ID: <bm65am$ptj$1@news1.tilbu1.nb.home.nl>

Luc Gyselinck wrote:

> I know about this paper.
>
> Indeed, the optimizer_index_caching parameter can be calculated by looking
> at the ratio of the logical and physical reads. But these counters are
> totals of data AND index blocks. But we need the counters for the index
> blocks ONLY (to be more accurate).
>
> Another thing is that in a DEVELOPMENT environment, these counters do not
> reflect the PRODUCTION environment. Many developers run 'test' (and most of
> the time 'bad') SQL that will make the results of these counters more or
> less useless. Maybe you should measure this ratio in the production
> environment, calculate the value of the parameter and copy it over to the
> development environment and do your tuning?
>

That's called the acceptance stage...

> I will re-read the paper if have my other computer switched on (this one has
> no MSWORD installed).
>
> Thanks for the reaction.
>
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> news:O8Tgb.141633$bo1.37865_at_news-server.bigpond.net.au...
>

<snip!>

>>Hi Luc,
>>
>>If I may, I would recommend the paper "The Search For Intelligent Life In
>>The CBO" by Tim Gorman at www.evdbt.com as an excellent introduction on

>
> how
>

>>to possibly tune these parameters. It provides some sensible techniques on
>>how to determine appropriate values rather than the broad generalisations
>>(which may or may not be suitable) offered by others in this thread.
>>
>>Good Luck
>>
>>Richard
>>
>>

>
>
>

Read it with great interest

-- 
Regards, Frank van Bortel

Received on Fri Oct 10 2003 - 06:38:41 CDT