Perfect. Thanks for the clarification.

My understanding is that SQL Server will use the primary key index in order to optimize the nonclustered indexes (I may be way off on this, so let's start with...