Hello everyone. I have a table (emps) (id,name) (id is pk). this table have 2.000.000.000 rows.
Now i want to search for name column like this (Select * from emp where name like ‘Has%’ or etc)
which index type must i have used ? for realy good performance
Thank you very much