query hints

Posted in 2003

tomL — 1 Jul 2003 13:44:07 -0700 — source: Usenet: comp.databases.informix

hello all, does informix have the ability to include query hints comparable to something like sql servers INDEX = index_name and (FAST 10)? thanks in advance, Tom

↪ replying to tomL

Art S. Kagel — Tue, 01 Jul 2003 18:41:41 -0400 — source: Usenet: comp.databases.informix

On Tue, 01 Jul 2003 16:44:07 -0400, tomL wrote: > hello all, > does informix have the ability to include query hints comparable to > something like sql servers INDEX = index_name and (FAST 10)? > > thanks in advance, > Tom Yes, look up OPTIMIZER DIRECTIVES in the Guide to SQL Syntax manual. Art S. Kagel

Related threads

Different instances with markedly different times