I got a table that gets updated every half a sec. Multiple columns. The table has 4k rows.
Is it wise to creat indexs and use them when I select ?
Short answer: Yes.
Not so short answer: Definitely.
Long answer: Show us the queries (SELECT/UPDATE/DELETE) that you use on that table. We can make the answer even longer.
But. Do not simply "index every column". We will at each query and find the optimal index for it.
Answered By – Rick James