Thanks Gail, Awesome as always.
I have a small Confusion. Lets assume I have a table "Emp_details" with 4 columns-Emp_ID(primary key which creates clustered index by default), Name, Designation and Location and table has a million rows.
How does index works when i query table with where condition on "Name" column as shown below.
SELECT * FROM Emp_details where Name='ABC'
Thanks in Advance