I'm creating Type of ca. 100.000 rows where String contains single alphabet character only, does Prisma optimize this on database ... should I be worried?

100k rows shouldn't be an issue

on SQL I could customize string field size and such, not an issue here then?

I don't think you need to worry, but I don't know :) just an educated guess