Antwort: Re: [DB2-L] Antwort: [DB2-L] [DB2 V8 z/OS NFM] complex join using VARCHAR and

Roy Boxwell

Antwort: Re: [DB2-L] Antwort: [DB2-L] [DB2 V8 z/OS NFM] complex join using VARCHAR and
Hi Walter!
I just checked and the problem with the ELSE was to do with the DSNTIAUL
program adding a strange extra byte and nothing to do with index access or
not! Whoops!...guess I need a coffee....
but back to the problem...what is the column def of the D.GJ_SL column? What does it have in the SYSCOLDIST and how does the index look?
(Cluster, Leafs etc) I have seen in V8
that it changes its access path for the WEIRDEST reasons... I had one
query where it insisted on using a rubbish index just to avoid an ORDER
BY, after forcing data access on a not-needed
column it then used the right index, added a sort and was 500 times
faster...

Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Strasse 5
40470 Duesseldorf/Germany
Tel. +49 (0)211 96149-0
Fax +49 (0)211 96149-35
E-mail [login to unmask email]
Homepage www.seg.de





Walter Janißen <[login to unmask email]>
Gesendet von: DB2 Data Base Discussion List <[login to unmask email]>
03.01.2006 13:11
Bitte antworten an DB2 Database Discussion list at IDUG


An: [login to unmask email]
Kopie:
Thema: Re: [DB2-L] Antwort: [DB2-L] [DB2 V8 z/OS NFM] complex join using VARCHAR
and CHAR


Roy

Thank you for your response. I just checked it, but it didn't work. Same
explain.

But if it did, that wouldn't be the explanation, because comparison
between
NULLABLE and NOT NULLABLE is indexable (I think since V7).

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm