Re: Optimistic

     I believe the improvements to the Query optimizer are in the area 
     of parallelism. By being able to break the query down into 
     independent units that can be performed in parallel, performance 
     will scream. Also, I believe I heard that IBM is introducing a new 
     technique for building access paths. 


______________________________ Reply Separator _________________________________
Subject: Optimistic 
Author:  <MIDRANGE-L@midrange.com > at INET_WACO
Date:    2/19/99 8:49 AM




I also found this interesting tidbit at:

http://www.zdnet.com/pcweek/stories/news/0,4153,388831,00.html


"With the optimizer, a query that took 2 hours now runs in 35 seconds,
                 according to officials."

Sounds like they are selling us the Brooklyn bridge.  The optimizer works
using existing
statistical data and the SQL statement. Does the product rewrite a user
query full of select/omits?

Dan Jahr





+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---