Re: ANY IDEA ON USING INDEX FOR ORDER BY

Posted in 1998

W. H. SMITH — Fri, 16 Jan 1998 18:01:27 GMT — source: Informix-list mailing list archive (1991-1998)

Art S. Kagel wrote: . . . snip . . . > this to Informix and asked for a SET OPTIMIZATION FIRST_ROWS option > (actually I called it SET OPTIMIZER GOAL FIRST FETCH) and voila this > option was added to the plan for 7.3 and tested in 7.24! It was QA'd > in 7.24 in November and is now a supported feature in 7.24. > It's active on 7.23.UC4 on the HPUX10.01 platform, but is it 'supported'? John Carlson Informix DBA WH Smith, Inc.