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

Reply via email to