Hello,
I don't know if we can do this other databases but we can create indexes in mysql at the time of creating table.
What I want to know is are the indexes updated automatically as and when we insert new data or update existing data?
I am quite ignorant about these things, so my question might not make sense.
Thank you.