Re: How Informix determines Index

From: "ASA GSI" <jbruce@asaglobalserv.com> > >How does Informix determine the index for an SQL statement if the table has >more than one index and how can a programmer try to use the best/fastest >index? It does a cost calculation. If you think you're better and you have 7.30 or later, look for optimizer directives in the manual. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com