Speed up database queries

Question

If I had a table in a database with millions of entries: Would it make sense to split the table in order to perform faster queries?
Eg table "names_a", "names_b" and so on, instead of only one table?

Answer 1

Fu Foy

Indexing play very important role. So by using which column you are getting data, that column should have index.