Re: Choosing Indices

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