Hey. Tell me, please, when do you need to add indexes to the mysql table? Once at table creation or each time at INSERT'e? And then on the Internet a lot of articles on the topic of what they are for, and how they work, but nothing about the addition is said ..

    1 answer 1

    What are indexes and why they are quite clearly described in this note: " Using indexes in MySQL (mysq; database index optimization) "

    • Thanks, the article has written a lot of what others are missing. I understand that if I make samples for one field, is it enough to add the corresponding index once and that's it? - sinedsem
    • Indexes are properties of a table / base (scheme), respectively, adding indexes, should be within the framework of creating a schema, i.e. where you do CREATE TABLE , in the sense that you do not have the question "should I do CREATE TABLE for each INSERT ?" - zb '
    • @eicto, okay, understandable
    • but, everything is fine, I found where the names look SHOW INDEX IN tblname
    • @huffman thanks again - sinedsem