Thanks. Any idea whether this issue is specific to SQLServer? Or we will see the similar behavior in Oracle and MySql Also? ( i have not yet tried). I am...

Yes you are absolutely right. When i used the following query:

SELECT AGE FROM CUSTOMER WHERE AGE = 3; it picks the right index. But my requirement is i need almost...