Hi,

When I read about non clustered indexes I come accross this descritption:

Each index row in the nonclustered index contains the nonclustered key value and a row locator. This locator points to the data row in the clustered index or heap having the key value.

Can someone please explain what exactly is the key value? If the row locator points to the actual row of data, then what is they KEY value and what is it used for please?? (e.g., why is it needed if the row locator points to the row of data?)

Thanks.