Removed BlockFeatureAssignments.ccvbID index (cID, cvID, bID) since it's a complete overlap of the primary key (cID, cvID, bID, faID)

Added BlockFeatureAssignments.faID index (faID, cID, cvID) for where clause and potential join to FeatureAssignments table

Added BlockFeatureAssignments.bID index for potential join to Blocks table