Path: utzoo!attcan!uunet!decwrl!sdd.hp.com!zaphod.mps.ohio-state.edu!sunybcs!rutgers!mcnc!rti!dg-rtp!roadkill!cohend
From: cohend@dg-rtp.dg.com (Dave Cohen)
Newsgroups: comp.databases
Subject: SQL Precompilers
Message-ID: <1990Jul26.141643.6361@dg-rtp.dg.com>
Date: 26 Jul 90 14:16:43 GMT
Sender: usenet@dg-rtp.dg.com (Usenet Administration)
Reply-To: cohend@dg-rtp.dg.com
Organization: Data General Corporation, Research Triangle Park, NC
Lines: 22

I would like to find out from experienced users/developers which
SQL RDBMs offer true preoptimization. I'm referring to precompilers
that process host languages with embedded SQL statements, 
optimize the statements based on database statistics and
indexes, and generate calls that refer to some statement identifier.
Simply massaging the SQL into calls that pass the actual
statement text is definitely not good enough. Neither is forcing
users to actually make calls that store that statement in the database
(ie, Sybase stored statements). It appears that most of the database
vendor hype ignores precompilation, but precompiled applications
run faster and are easier to code than call level SQL.

In particular, I'd like to hear about the 'biggies' : DB2 (pretty sure
this does), Oracle, Ingres, Informix, Sybase, Empress, etc.

If you want, email me and I'll post a summary.
Thanks.

David Cohen                      |    "There's nothin' wrong with goin'    
cohend@dg-rtp.dg.com             |     nowhere, baby, but we should be   
{world}!mcnc!rti!dg-rtp!cohend   |     should be goin' nowhere fast."       
Data General Corporation, RTP, NC|                  - Streets of Fire