Re[2]: Choosing Indices

Go to http://www.garpac.com/ifaq05.html#5 This contains an FAQ on Informix. Look at section 5.8 - "How to convince the optimizer to use indexes YOU want". I'm not sure, but I think the scenario they describe is what you're looking at also. ______________________________ Reply Separator _________________________________ Subject: Re: Choosing Indices Author: Nick Nobbe <nnob@loc.gov> at smtpgate Date: 1/30/96 7:21 PM On Tue, 30 Jan 1996, Joseph Kormann wrote: } Is there a way to choose the main index that you want to search on? } } If I have a where clause with two statements. Both statements have their } own indices. Problem is I want the query to run the initial index off the } second statment, then subquery to the first statement. } } I've tried reversing the statment order, but SQL still does it the same } way. Any help? } Joseph, No offense but can you show us what you're trying. Yours, Nick