+ 1

Speed up database queries

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?

2nd Apr 2022, 7:42 PM
Fu Foy
Fu Foy - avatar
1 Odpowiedź
+ 1
Fu Foy Indexing play very important role. So by using which column you are getting data, that column should have index.
3rd Apr 2022, 2:45 AM
A͢J
A͢J - avatar