creating indexes will lock the tables if not mistaken, the problem about database is that many of us just don't study enough to make sense out of it