All,

With Henrik's input, I've been able to deduce that the following Index improves the "Latest Edition" query considerably:

CREATE UNIQUE INDEX ix_Books_Test1 ON dbo.Books(BookTitle, BookEdition DESC) INCLUDE (BookPublishDate, BookAuthor)

This is an ideal index created to serve this query only, and may not help others.

Regards,

Lawrence.