this is a big one and probably one of the first things that I noticed (and people will notice) coming from other similar tools (Toad, old SQLNav, etc.).
I am writing down the following as a kind of use case that reflects what I am doing every day.
In my job I have to write and execute every day lots of single queries to diagnose problems in the payroll system, so I have to retrieve and check data from the db and reuse the information I found to write new queries.
I thought this was an easy test, but actually the current UE is making this task next to impossible.
I write down a simple query and execute it. The UE will spawn a new tab with the selected query without bringing it in foreground and in focus. The first sensation is that nothing happened if the query is fast, while everything will seem to hang if the query is slow. The fact that the results of my query are hidden is really disorienting.
Then I notice that there is a new tab, I switch to it and I find the results. Fine, now I want to improve the query and add a new condition. Guess what?
The query is read only in this new tab and I cannot modify it. So I have to go again to the old tab to change the query and re-execute it. That’s really bad usability.
Can you imagine what nightmare it can be when there are dozens of related queries in one file and I want to execute them manually one by one, reusing the data found in one query to feed another query?? How will I know which tab belongs to which query when I am looking for the results??
Anyway, I finally found my data and I want to write down a new query using some information coming from the previous query results. I select the desired field in the results pane and I look for a button to copy the value. Mmmmh, nothing in sight. Ah, maybe the standard cut icon (next to the printer in the edit toolbar) will do the job. Press it, switch tab, position the cursor and paste. Nothing happens…
Too bad, I go back and I try the universal copy+paste shortcut (that is CTRL+C and CTRL+V). Nothing happens again…
That’s really very bad usability.
Now I have two single SQL statements in my UE page, how do I execute one instead of all of them? I have to select every time the chosen query and press Shift+F9.
Ok, fine, but it would have been nice to have the autoselection of the current SQL statement as in TOAD, PL/SQL developer, SQL Developer, the open source TORA, etc. etc. (yes, I tried all of them…)
Good, I execute the query and I notice that I cannot use substitution variables. That’s another very bad thing (but I already pointed it out in another thread).
I start writing a query on the all objects table (remember I am testing this on a VERY big db) and suddenly the auto completion panel pops up. I don’t want to select an object type, at least I want it to show me the objects with the same starting letters as those I already wrote down. No way, press ESC to get rid of it.
So let me see where I was? Ah, yes, it was:
SELECT * FROM all_objects a WHERE a.
As soon as I write the dot, the autocompletion panel pops up again, but then it lags and after a few seconds it freezes the program. I see the dreaded label Not Responding at the top of the SQLNav window. I wait. Well, now I am forced to kill the program because after 15 minutes it was still not responding.
I hope to have given you a clue on several problems I encountered on a very short test session of Beta4. I am not going to test (yet) the fancy stuff, I think that we should get straight the easy things first.
Thanks for the attention,