Be very careful, then, as the optimizer will (usually?) not use the index if the condition is not part if the query.