This question could be best addressed by someone on the DB2-L listserv,
which you can find at http://jupiter.ryci.com/archives/db2-l.html
That said ...
>Are Partition Scan and/or I/O Parallelism used if my query hasn't in the
>WHERE clause a predicate on partitioning columns ? Are they used if
>the access path is via NPI ?
I believe the answers to your questions are both no, if the partitioning columns
are not in the where clause. You can verify this easily by explaining the SQL
you are working with and checking the following values in the PLAN_TABLE:
PAGE_RANGE If there is a 'Y' you are doing partition scan (I have no clue
why IBM named the column in this way)
PARALLELISM_MODE If there is an 'I' you are doing I/O Parallelism
Hope this helps
Gisella Santandrea wrote:
> I'm sorry, this list requires that you be a subscribed user to
> execute this command or post to the list.
>
> :From owner-db2eug Thu Mar 29 06:24:56 2001
> :Received: from small-4.inet.it ([212.239.0.40])
> by lists1.ba.best.com (8.11.1/8.11.0) with ESMTP id f2TE4PV24856
> for <[EMAIL PROTECTED]>; Thu, 29 Mar 2001 06:04:25 -0800 (PST)
> (envelope-from [EMAIL PROTECTED])
> :Received: (from trusted@localhost)
> by small-4.inet.it (8.11.1/8.11.1) id f2TE4E069362
> for <[EMAIL PROTECTED]>; Thu, 29 Mar 2001 16:04:14 +0200
> :Received: from cgiisdn.inet.it(194.185.218.26) by small-4.inet.it via
> I-SMTP
> id queue/s-194.185.218.26-sLKEqa; Thu Mar 29 16:04:14 2001
> :Message-ID: <[EMAIL PROTECTED]>
>
> Hi All,
>
> I am working with DB2 v.5 for OS/390 and I have a problem about a
> partitioned tablespace.
> I want to create a partitioned tablespace but I'm not sure about
> partitioning index.
> My question is:
> Are Partition Scan and/or I/O Parallelism used if my query hasn't in the
> WHERE clause a predicate on partitioning columns ? Are they used if
> the access path is via NPI ?
>
> Thanks in advance
>
> Gisella
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
