What to choose for a quick search in the database?

Question

SQL

There is data (1700000000 lines). Each line contains two identifiers (first name and last name).
What to choose for a quick search in the database in order to search for a name by query in the least amount of time?

Answer 1

solr, elatsic search :-)

Answer 2

What is the question?
What DBMS? - Oracle? Postgres, MariaDB Galera Cluster
How to build an index? - depending on the DBMS

Answer 3

even interesting, but what a billion records? what is there?

Answer 4

Postgresql needs to be prepared
Sphinxsearch is easy to prepare, but you also need
Clickhouse - almost no need to prepare