Erick- Thanks for the pointer; in my app the difference is between 30 milliseconds and 45 milliseconds (and this is a once-a-day kind of thing), but hey it's always worth doing something the better way in case my index ever gets a whole lot bigger or the use case changes-- thanks.
Donna L. Gresh Business Analytics and Mathematical Sciences IBM T.J. Watson Research Center (914) 945-2472 http://www.research.ibm.com/people/g/donnagresh [EMAIL PROTECTED] "Erick Erickson" <[EMAIL PROTECTED]> wrote on 12/08/2008 09:28:16 AM: > is empid indexed? If it is this should run *much* faster if you used > TermEnum/TermDocs to fetch all the empids...... > > FWIW > Erick
