Re: 7.30 Performance problems

Clint Kunz wrote: > > >We upgraded to 7.30 this past weekend and have noticed performance problems > with some queries. > > Our organization has also recently attepted an upgade to 7.3 UC2 (HP_UX > 10.20 OS), The performance seems good but we have one underlying problem to > solve. For some reason we have to append ownership to one of our tables if > the tablename has to be used in a column reference, for example in the > select statement, or join "case.int_case_num" has to be> "informix.case.int_case_num" referencing the column without table > qualification is ok, and the reference to the "case" table in the from > clause does not require ownership to be specified. In addistion this only > occurs on our "case" table. No other table is affected. I have opened a case > on this but neither Informix or myself has come up with an explanation for > this oddity. I have the explanation. CASE is now a keyword in 7.3. V7.3 added the Oracle CASE clause syntax to the select statement. The qualification of the tablename with owner name in the where clause resolves the symantic conflict between the tablename and the WHERE clause CASE sub-clause. If you add an alias to the tablename in the FROM clause you will be able to use the simpler alias instead of the cumbersome owner qualified tablename. Art S. Kagel