my point i think is, when i just index sex, then the index is not used ... quicker ftswhen i index all the columns in the select including columns in the where clasuse .. the index is used! (why is it not quicker still to do a full table scan)Could you help me understand the logic behind this? .. and then ill leave you alone SteveC