RE: SQL Syntax

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

> From: Alexei Pytel
>
> There is no black magic.
> Run DB monitor for your query and use SQL Visual Explain from Operations
> Navigator.
> It will show you how your query was performed in more detail than you want

See my post on this.  Sort of fittingly with the rest of this conversation,
Visual Explain shows a lot of data on the SQL statement, but very little
real information.  Nothing in all those wonderfully verbose logs indicates
WHY one statement took 50 times longer than the other.  Sure, there are
differences, but nothing meaningful, at least to me.  Perhaps I'm an idiot,
but I challenge anyone to read my logs and decipher the "why" from the data.

As I said in a different post, there's data, and then there's information.

Joe