Further to your scenario, Can you help me with your feedback and comments on the below scenario

Considering the same scenario as yours

Scenario 1: I have one more index lastname , emailid then when i fire a query then how will be the execution plan be for following WHERE clauses

1. WHERE LastName='ABC'

2. WHERE LastName='ABC' AND EMAILid ='abc@xyz.com'

3. WHERE LastName='ABC' AND EMAILid LIKE 'abc@%'

4. WHERE LastName='ABC' AND firstName ='PQR'

Thanks in advance

Regards,

Kiran R. Khot