Count RowIDs with a common Prefix

[Yamini Joshi]

Hello all

My keys are of the form rowID:otherID where there are multiple otherIDs for
a RowID. I want to know the count of all the otherIDs within a rowID. What
would be the most optimal way to implement this?

Best regards,
Yamini Joshi