Are "Help me with this query" questions on topic here or are they 'too localized'?
I have a table, with indexes but the explain seems to indicate that the indexes are not used and I'd like some advice on how to speed it up.
Are "Help me with this query" questions on topic here or are they 'too localized'?
I have a table, with indexes but the explain seems to indicate that the indexes are not used and I'd like some advice on how to speed it up.
Basically the two commenters above (Rachel, Mat) summed it up nicely. You should feel free to ask the questions that you think are on target, but make sure that they are well-defined, that you have included your troubleshooting steps, what you think is broken, why you don't think you can fix it, and any ancillary data that may be helpful.
For example, you mention a explain. If you can insert that in the text of the post (use the { }
code formatting block after pasting, in the editor above the post entry box to indicate code formatting) then by all means do so, but if not, maybe provide a link to a gist or pastebin that has the relevant details. There's also sqlfiddle, if you want to reproduce the basic issue you're seeing.
Otherwise, so long as you've done the above, we should be good on you posting whatever you think is relevant.