RE: Forcing the use of an index

See the Performance Guide for use of optimizer directives. Bill http://www-306.ibm.com/software/data/informix/pubs/library/ids_94.html > -----Original Message----- > From: David Reed [SMTP:david.reed@compuwin.co.za] > Sent: Friday, July 09, 2004 9:07 AM > To: informix-list@iiug.org > Subject: Forcing the use of an index > > > Hi > > If I have more than one index on a table, how do I force the use of a > specific index, on a select statment? > Can I do it in the creation of a view? > > Is there any documentation on this issue that I can look at? > > David Reed > david.reed@compuwin.co.za > > > > > sending to informix-list sending to informix-list

"Bill Dare" <dareb@jevic.com> wrote in message news:ccmamf$gjd$1@news.xmission.com... > > See the Performance Guide for use of optimizer directives. Be mindful that "directive" is a euphemism. "Polite request" might be more accurate.