Folks, Does anyone know that in order for the optimizer to choose "Index skip scan" on a concatenated index where the first column is not very selective but the second one is, approximately what type of selectivity on the leading column the Optimizer look for before deciding to take this route? Thanks Amir