Re: Indexing strategy

Posted in 1993

Karl Funk — 28 Apr 93 09:46:31 GMT — source: Informix-list mailing list archive (1991-1998)

1rk2ciINNrhr@emory.mathcs.emory.edu writes: >: Stuff deleted.. >: If you define the unique 3-part index before the >: non-unique 2-part index, the query optimizer may already be using the 3-part >: index (so I have heard), since the optimizer finds the 3-part index first, >: and it will do the job. >: Is this true? Can some one with the source confirm this? Exactly how does it decide which index to use? Regards, Karl Funk.