Dan,

Thank you for the fast reply. Runstats are run daily, optimization is 5 and I am testing this on a low usage DB, although it is behaving the same here as production and prod is much higher usage.

Ideas?

> To: "LazyDBA Discussion" <[Email address protected]
> From: "DANIEL CALLAHAN " <db2udbdba-ezmlmshield-x18067545.[Email address protected]
> Date: Tue, 23 May 2006 10:42:19 -0400
> Subject: Re: Index usage
>
>
>
>
>
> Can we assume you have done runstats?
> and maybe set the optimization to at least 3
> and make the table volatile, if the activity is high?
>
>
>
>
>
>
> "paul"
> <db2udbdba-ezmlms
> hield-x48947348.x To
> [Email Address Removed] "LazyDBA Discussion"
> a.com> <[Email address protected]
> cc
> 05/23/2006 10:31
> AM Subject
> Index usage
>
>
>
>
>
>
>
>
>
>
> Hello all,
>
> Have a rather strange occerence here that is perplexing me and am in need
> of a little guidance. Running AIX 5.3 UDB "DB2 v8.1.1.80", "s041221",
> "U800400", and FixPak "8". I have many occurrences of specifying a join on
> two tables on an index, but the optimizer is determined to do a table scan.
> I would like to avoid optimizer hints as they could bite me in the
> preverbial rear down the road. I did find where I had the DFT_DEGREE set
> to one, shich of course is no paralellism at all. Are there any other DB
> parameters that you are aware of that I should be looking at before going
> after fix packs?
>
> TIA
>
> PL
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html

DB2 & UDB email list listserv db2-l LazyDBA home page