wrong list aswell ...
Les
-----Original Message-----
From: Gisella Santandrea [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 12:49 PM
To: [EMAIL PROTECTED]
Subject: DB2EUG: Partitioned tablespace
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
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed.
Sony cannot accept liability for statements made which are clearly
the sender's own and not made on behalf of Sony.
(03)
**********************************************************************
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
