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




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