RE: SQL Syntax

Joe,  Joe,  gee

You said you didn't like the "Magic" the optimizer does for you figuring
out the access plan
but you then say;

 >I'd like to see an application request wizard that generated the
>best possible SQL syntax for a request

Wouldn't that be more "Magic"


> In my era, our database design was dictated by its use,

ah, you hit a nerve on that one.  It is my belief that in
OUR day,  we designed DB's for OUR use OUR program, OUR everything.

Those days are over.  It's the user's data base.  They should have
direct access to it, and you cannot predict their ad hoc uses
from a myriad of interfaces.  The Joins, Views should be designed
just as much for the End User's need as it is for OUR program's
needs.

And SQL will be used by all those PC based interfaces.

Last post I swear.

Respectfully
John