Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!tut.cis.ohio-state.edu!pt.cs.cmu.edu!andrew.cmu.edu!bg0l+
From: bg0l+@andrew.cmu.edu (Bruce E. Golightly)
Newsgroups: comp.databases
Subject: Re: SQL Precompilers
Message-ID: <0afnkLa00UhBQ1qkxT@andrew.cmu.edu>
Date: 26 Jul 90 18:53:11 GMT
References: <1990Jul26.141643.6361@dg-rtp.dg.com>
Organization: Carnegie Mellon, Pittsburgh, PA
Lines: 21
In-Reply-To: <1990Jul26.141643.6361@dg-rtp.dg.com>

I'm not sure that you'd like the kind of pre-optimization you described. If the
characteristics of the data base changed to any real extent, performance
could fall right through the floor. Good performance can be related to 
optimization that makes use of statistics on the data base AS IT PRESENTLY
EXISTS. Old stats may be very misleading!!

Somewthing that works much like what you describe is a real stored procedure.
Ingres 6.2 and up alloow the creation of things they call database procedures.
They are SQL "scripts" that are stored as objects wihtin the data base. They 
may have permissions assigned, protecting the procedure and the data it 
references from the user.

#############################################################################
                                     !                                      
Bruce E. Golightly                   !  bg0l@andrew.cmu.edu (BeeGeeZeroEl)  
Chief of Data Base Development       !  (412)268-8560                       
Telecommunications Group             !                                      
Carnegie Mellon University           !  UCC 117, 4910 Forbes Ave.           
                                     !  Pittsburgh PA 15213-3890            
President, Western Penna IUA         !
#############################################################################