I go through some of the blog post and found i can improve my lookup speed using index, and also in some discussion i found that database usually apply auto indexing to the id or pk of the table without running any manual command.
I am currently on two projects which has two different dbs
Postgres and MySQL
any other suggestion for improving the lookup speed for both the dbs will appreciated.