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 ='email@example.com'
3. WHERE LastName='ABC' AND EMAILid LIKE 'abc@%'
4. WHERE LastName='ABC' AND firstName ='PQR'
Thanks in advance
Kiran R. Khot