Re: First time to learn SQL - looking for suggestions.

[Geoff_Start@xxxxxxxxxx (Geoff Start)]

     Performance tip
     
     The order of the "WHERE" clauses in your SQL statements should 
     correspond wherever possible to the order of the keys in existing 
     logical files. They will still work without considering this, but on 
     big files the I/O(and hence processing time) will be enormous.
     
     Example. BPCS V6.004 has an SQL update statement to the EIL file in 
     either program BIL530B or BIL540B. This statement has no corresponding 
     logical file. Before a new logical access path was added, the program 
     was accessing 1 million+ records(the whole file) to update one record. 
     
     
      


______________________________ Reply Separator _________________________________
Subject: First time to learn SQL - looking for suggestions.
Author:  Forwiw@aol.com at Internet
Date:    15/02/00 19:08


     
    Hello to all,
     
        Looking for suggestions or directions to either books or classes, 
etc.,
        that teach you beginning level SQL, then to build on further learning.
     
        This is a result of first time exposure to BPCS programming language 
        called AS/SET.
     
        Any info will be greatly appreciated.
     
        Thanks,
        Sandy
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com. 
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com. 
| Questions should be directed to the list owner: dasmussen@aol.com
+---
Received: from ccgate.bausch.com ([161.242.3.9]) by ccgate.bausch.com with SMTP
  (IMA Internet Exchange 3.11) id 00000EB7; Tue, 15 Feb 2000 20:31:56 -0500
Received: from 192.160.127.93 by ccgate.bausch.com (InterScan E-Mail VirusWall
NT); Tue, 15 Feb 2000 20:31:56 -0500 (Eastern Standard Time)
Received: (from uucp@localhost)
        by uucphost.mcs.net (8.9.3/8.8.8) with UUCP id TAA05568;
        Tue, 15 Feb 2000 19:31:37 -0600 (CST)
Received: (from majordom@localhost)
        by midrange.dynip.com (8.9.3/8.8.7) id SAA11389
        for bpcs-l-outgoing; Tue, 15 Feb 2000 18:11:49 -0600
Received: (from uucp@localhost)
        by midrange.dynip.com (8.9.3/8.8.7) with UUCP id SAA11364
        for BPCS-L@midrange.com; Tue, 15 Feb 2000 18:11:45 -0600
From: Forwiw@aol.com
Received: from imo-d02.mx.aol.com (imo-d02.mx.aol.com [205.188.157.34])
        by uucphost.mcs.net (8.9.3/8.8.8) with ESMTP id SAA95434
        for <BPCS-L@midrange.com>; Tue, 15 Feb 2000 18:08:54 -0600 (CST)
Received: from Forwiw@aol.com
        by imo-d02.mx.aol.com (mail_out_v25.3.) id i.19.12e8831 (4262)
         for <BPCS-L@midrange.com>; Tue, 15 Feb 2000 19:08:06 -0500 (EST)
Message-ID: <19.12e8831.25db4466@aol.com>
Date: Tue, 15 Feb 2000 19:08:06 EST
Subject: First time to learn SQL - looking for suggestions.
To: BPCS-L@midrange.com
MIME-Version: 1.0
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit
X-Mailer: AOL 4.0 for Windows 95 sub 39
Sender: owner-bpcs-l@midrange.com
Precedence: bulk
Reply-To: BPCS-L@midrange.com
X-List-Name: BPCS Users Mailing List (BPCS-L@midrange.com)