As a db grows fetching distinct values gets more and more time consuming. What is the best practice for solving this problem:
1) Create separate tables for each columns of which distinct values are required
2) Create one table with two columns: 1)name of the column and 2) multiple distinct values (Is it possible to store in a cell multiple values, such arrays etc)
3) Do you know some more proficient solution?