Fun with DB2/400 Optimizer...well, not quite.

I have a recurring problem with the DB2/400 optimizer that I'm hoping others
can shed some light on. This post is pretty long (sorry) so I will begin
with my questions before you guys get tired of reading.  ;-)

____________________________________________________________________________
__
My first issue is that DB2/400 seems to want to table scan WAY more often on
this particular data selection than it should.  The selection criteria only
selects 4665 records of the 18.5 million in a table.  There is some index
experimentation I could do here.  For instance, my index is actually
beginning with my least selective column (GLLT), however I've done this
because I've had issues in the past by starting with columns I am doing
range (BETWEEN) or >=/<= selection on.  Is there a way to force the
optimizer to use indexes, or force it to select the 4665 relevant records
BEFORE the join???

My second issue is the creation of views.  Most of these queries I have to
turn into views.  Even after I have a very well tuned query / index
combination, turning the SQL into a view ALMOST ALWAYS (99%) results in
table scans.
____________________________________________________________________________
__

Some general info...

Table t1 is about 100 columns wide, has 18.5 million rows, and is 14GB in
size.  Table t2 is about 50 columns wide, has 4500 rows, and is 3mb in size

There are lots of indexes, but the relevant ones are:

IDX_T1 (GLLT asc, GLDGJ asc, GLDSYJ asc, GLMCU asc)
IDX_t2 (MCMCU asc)

Instead of obfuscating with pseudo code, here is the real deal.

Query1:

SELECT t1.GLMCU
, t2.MCDC
, t2.MCRP01
, t1.GLOBJ
, t1.GLSUB
, t1.GLEXA
, t1.GLEXR
, t1.GLAA
, t1.GLIVD
, t1.GLDGJ
, t1.GLDCT
, t1.GLPO
, t1.GLLT
, t1.GLDSYJ
FROM t1
INNER JOIN t2 ON t2.MCMCU = t1.GLMCU
WHERE t1.GLLT='AA' AND t1.GLDSYJ>=106072 AND t1.GLDGJ<=105365

Results mixed.
50%:  TABLE SCAN on t1, TABLE SCAN on t2 with temp hash table, hash join
50%:  Index Scan IDX_t1, Index Scan IDX_t2, table probes, then nested loop
join.

If I turn Query1 into a view and SELECT * FROM View, this ALWAYS results in
tables scans and overnight processing.

Query2:

SELECT t1.GLMCU
, t2.MCDC
, t2.MCRP01
, t1.GLOBJ
, t1.GLSUB
, t1.GLEXA
, t1.GLEXR
, t1.GLAA
, t1.GLIVD
, t1.GLDGJ
, t1.GLDCT
, t1.GLPO
, t1.GLLT
, t1.GLDSYJ
FROM t1
INNER JOIN t2 ON t2.MCMCU = t1.GLMCU AND t1.GLLT='AA' AND t1.GLDSYJ>=106072
AND t1.GLDGJ<=105365

Results:
100%:  Index Scan IDX_t1, Index Scan IDX_t2, table probes, then nested loop
join.

If it turn Query 2 into a view and SELECT * FROM View, results are mixed.
5%:  Index Scan IDX_t1, Index Scan IDX_t2, table probes, then nested loop
join.
95%  TABLE SCAN on t1, TABLE SCAN on t2 with temp hash table, hash join

Query3:

SELECT t2.MCDC,  t2.MCRP01, ilv1.*
FROM
(
SELECT GLMCU
, GLOBJ
, GLSUB
, GLEXA
, GLEXR
, GLAA
, GLIVD
, GLDGJ
, GLDCT
, GLPO
, GLLT
, GLDSYJ
FROM t1 WHERE GLLT='AA' AND GLDSYJ>=106072 AND GLDGJ<=105365
) ilv1
INNER JOIN t2 ON t2.MCMCU = ilv1.GLMCU

Results:
100%:  TABLE SCAN on t1, TABLE SCAN on t2 with temp hash table, hash join

Turning this into a view has same result.


Any ideas?