Partition Index by two characters
Hi,
We have a big table with employees's name and surname, among others columns.
Sometimes we need get the employees who surname start by two letters, for example: employees´s surname start by "SM", and we can´t make our mind whether to create a text index or a parttion index.
Can we create an partition index by the first two letters of surname?
Regards,
Lamobe
We have a big table with employees's name and surname, among others columns.
Sometimes we need get the employees who surname start by two letters, for example: employees´s surname start by "SM", and we can´t make our mind whether to create a text index or a parttion index.
Can we create an partition index by the first two letters of surname?
Regards,
Lamobe
0