All,

Further to my last post: it's worth pointing out that following Blah's example, I have increased the number of rows in the dbo.Books table considerably to test this.

I used the following code snippet:

--Add additional data (run multiple times to get 500000 rows)

INSERT dbo.Books( BookTitle ,BookEdition ,BookPublishDate ,BookAuthor)

SELECT BookTitle, BookEdition, BookPublishDate, BookAuthor

FROM dbo.Books

GO 16

--Set BookEdition to BookId for better data profile

UPDATE dbo.Books SET BookEdition=BookId

NB: For the UPDATE to work, the BookEdition column datatype must be increased from the original SMALLINT datatype to BIGINT for example.

Thanks,

Lawrence