Semi-Optimistic

[Pete Massiello <pmassiello@xxxxxxxxxxxxxxxx>]

I was discussing this with some IBM folks, and while this is great stuff, 2
things are overlooked.

    I was told that this is 1) SQL, and 2) an SQL created Table.  It is not 
Query
and a DDS created table, which for the most part is what 99.9% of AS/400 systems
use.  So all that Vector Encoded Indicies, will not work for mere mortals who 
use
DDS.

    Why isnt this stuff set up to be used with DDS, when almost the entire
existing AS/400 population uses DDS, and not SQL to define their files.

    Just my opinion.

        Pete


Danny.Jahr@lawson.com wrote:

> 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
> +---

--
Pete Massiello
OS Solutions International
Phone: (203)-744-7854  Ext 11.
http://www.os-solutions.com
mailto:pmassiello@os-solutions.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
+---