SubscriberId = :subid 

AND ProviderId = :provid

AND IsActive = 'Y'

AND Published = 'Y'

SubscriberId and ProviderId are integers and should be in a compound index.  But IsActive and Published are CHAR(1) fields where the only values are either 'Y' or 'N'.

Should IsActive and Published also be included in the index or is it better to leave them out?

Dixoin