02.09.2017, 12:11
Quote:
Sorry, I must've misunderstood.
I doubt it, although I tend to keep my own tables under 20 columns if I can help it at all. I have 35 tables and the largest one (vehicle table) has 17 columns. I would still like to see the output of EXPLAIN. In phpMyAdmin (or whatever client you use) run your problematic query (with dummy data if you want) but insert the word EXPLAIN before it. The output should be a neat little table that outlines how the server will process this query. |