We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. Databases
  3. Indexes
  4. Indexes - 2

Indexes - 2

Which of the following statement is true about row locators in non-clustered indexes in MS SQL Server?

If the table does not have a clustered index, the row locator is the clustered index key for the row.
If the table has a clustered index, or the index is on an indexed view, the row locator is a pointer to the row.
If the table has a clustered index, or the index is on an indexed view, the row locator is the clustered index key for the row.
None of the above-mentioned statement is true.