Comment by VMtest

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