Where question

Hi !!

I have an idiot question, suppose that I have a table with these fields:

empl_id, name, address, zipcode, salary

And an index by empl_id, salary

How I should use the where clause to "take or use" that index

where empl_id = 'xxx'

   and salary > 10000;

or

where salary > 10000;

   and empl_id = 'xxx';

Regards,
Diego Received on Wed Oct 13 1999 - 10:20:37 CDT