Hi guys,
I need to create a huge table that will contain among other things two columns: first_name and last_name. I also want to create partitioning by list for this table, to hold one partition for each starting letter of either the first_name or the last_name.
The reason for this is to speed up querying the table that suffers the slow-changing-dimension syndrome: for the same SSN I have multiple addresses, phone numbers, driver licenses etc.
Any advice on how to create the partitioning function will be much appreciated.
Thank you in advance.