RE: New DB Performance Boost - For SQL Only!

["John Taylor" <john.taylor@xxxxxxxxxxxxxxx>]

Chan,


Based on the following paragraph from the announcement letter, it seems that
only SQL created indexes will benefit from the new PTF's:


Summary of cases where larger index page sizes used...

-SQL created indexes on SQL created tables
-SQL created indexes on CRTPF/DDS created tables
-SQL created constraints on SQL created tables
-ADDPFCST created constraints on SQL created tables


Regards,

John Taylor
Canada


> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of Chan Moon Wang,
> Daniel
> Sent: Sunday, July 02, 2000 7:41 PM
> To: 'MIDRANGE-L@midrange.com'
> Subject: RE: New DB Performance Boost - For SQL Only!
>
>
> Will these PTF bebefit Logical File created by DDS
>
> -----Original Message-----
> From: John Taylor [mailto:john.taylor@telusplanet.net]
> Sent: Friday, June 30, 2000 11:37 PM
> To: MIDRANGE-L@midrange.com
> Subject: New DB Performance Boost - For SQL Only!
>
>
> Folks,
>
> With the recent discussion about about DDS .vs. SQL, I thought
> the following
> IBM announcement might be of interest to some of you. Here is an excerpt:
>
> ---------------------------------
> Query Performance PTFs
>
> A set of PTFs were recently made available that can have a direct
> impact on
> query performance. These new PTF's enable DB2 UDB for AS/400 to create
> indexes (also known as logical files or access paths) with a
> larger logical
> page size (64K). Most AS/400 indexes today have a logical page
> size of only
> 4K or 8K. This larger page size makes indexes more attractive to the query
> optimizer and allows the database paging to be more efficient on a query.
> For example, one customer after applying the PTF's saw a 40%
> decrease in run
> time for a set of 15 queries that they frequently run.
>
> The larger page size only be used on indexes created over SQL tables and
> SQL-created indexes. The 64K logical page size will be used automatically
> for any index that is created over an SQL-created table - this
> includes both
> SQL-created indexes and indexes created for constraints.
> ---------------------------------
>
> The full article text can be found at
> http://www.as400.ibm.com/db2/ixszptf.htm
>
>
> Regards,
>
> John Taylor
> Canada
>
>
>
>
> +---
> | 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
> +---
>

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