On the image said that for heavy working loads you must indexing. But could be contradictory as you add more indexing on a table writing will become slower. What do you think?
Yes, that's a good point. If the flows are write-heavy, adding many indexes would only slow writes.
At least in my experience, the time to insert with indexes is always smaller than the time to read without indexes. Unless the latency of writes is critical for the application, I think it's usually better adding indexes!
On the image said that for heavy working loads you must indexing. But could be contradictory as you add more indexing on a table writing will become slower. What do you think?
Yes, that's a good point. If the flows are write-heavy, adding many indexes would only slow writes.
At least in my experience, the time to insert with indexes is always smaller than the time to read without indexes. Unless the latency of writes is critical for the application, I think it's usually better adding indexes!