RE: New DB Performance Boost - For SQL Only!

["Richard Jackson" <richardjackson@xxxxxxxxxxxxxxxxxx>]

Well, it says that they won't ...

"The larger page size only be used on indexes created over SQL tables and
SQL-created indexes."

Richard Jackson
mailto:richardjackson@richardjackson.net
www.richardjacksonltd.com
Voice: 1 (303) 808-8058
Fax:   1 (303) 663-4325

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