You always have a big data i.e. millions of rows in your tables, how would you partition it for optimum performance?

Give a couple of partitioning examples