Topic: How search in an index if there is no primary key works?
Can a question, but nevertheless.
There is a table on many millions records.
There there are not clustered indexes, and the primary key is not present.
How search in this case works?
For example, there is an index by date. I want to select records with date "20170831". What does SQL the Server?
In the execution plan I see that at first there is a search in an index (index seek), and then any RID Lookup. And did not understand that it.