Re: Set explain comments

> wayne@jones.mac.alt.na (Wayne Harlech-Jones) writes: > > Another question: I created a temporary table, created an index on it and > joined to another indexed table on the respective indexed fields. "set > explain" said the join query did not use the temp table index. Why not? > > Yours > Wayne > > |Wayne Harlech-Jones > |Windhoek, Namibia, Southern Africa > |wayne@jones.mac.alt.na >>>> I don't know, but you might want to be aware of the following error also if using temporary tables with OnLine 7.10: Bug: 38562 QUERY ON TEMP TABLE WITH OUTER JOIN RETURNS INCORRECT NUMBER OF ROWS First found in 7.10.UC1 (1995-04-05). At our site (OnLine 7.10 on SCO Unix 3.2.4.2) such a join simply doesn't return all rows. Some randomly distributed rows are lost without any warning or error code set anywhere! (Scary!) If we create an index on the temporary table the rows are returned however. Informix's responce so far is to not use temporary tables?!? They are waiting for a reproducible test case from us which we are preparing now. Nils.Myklebust@ccmail.telemax.no NM-data, Dalsbergstien 7, N-0170 Oslo, Norway My opinions are those of my company