What i would like to see in the explain window that when you click one of the boxes or one of the lines in the table then that part of the SQL is highlighted so i can better understand what is being applied and where i need to improve to make it better.
It would also be nice if it came up with a suggestion on how to improve it. eg 'Add index on x, y ,j' or use 'LEFT JOIN' or some other help would be nice.
thanks for your ideas! Your suggestions seem like a big help in understanding bad queries. Index suggestion is a complicated thing to do, so I do not know right now if we can achieve something like that. But we'll give it a try.
I'm testing Jet Profiler for a non-profit organization I work for. On my day job I work on an IBM System i with DB2. It has an index suggestion feature which we use profusely. You just click on the suggested index and it is created on the fly. This would be the number one most useful enhancement to Jet Profiler.
Thanks, Bjorn. I forgot to mention that System i DB2 also uses SQL, so it's SQL indices that are suggested and created. I'd be happy to provide screenshots if you like.