Re: Semi-Optimistic

New type of indices imrove search, but cannot be used for ordering records,
particularly for reading the file in a key order (this is in a nature of
these indices).
They will really improve SQL queries, because SQL operates over SETS of
records.
They cannot possibly do much about CHAIN-READE cycle.

Best regards
    Alexey Pytel



Pete Massiello <pmassiello@os-solutions.com> on 02/19/99 09:59:25 AM

Please respond to MIDRANGE-L@midrange.com

To:   MIDRANGE-L@midrange.com
cc:    (bcc: Alexei Pytel/Rochester/IBM)
Subject:  Semi-Optimistic





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



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