分区表或分区索引 [英] partioned table or partioned index
问题描述
我有一张桌子，我想分区。它有一个列c1，它有
100个不同的值。
我打算用分区索引对列c1上的表进行分区，
然后在表格上应用数据分区的二级索引。
然后我读到了分区表空间，我如何通过创建获得与
相同的行为
a分区表空间？我创建分区表空间，创建
表然后创建
分区索引吗？
我喜欢分区表空间的属性，因为我处理的
表的大小是非常大的？
任何想法和指示都是适用的。
谢谢，
Sumanth
Sumanth写道：
我有一个表，我想分区。它有一个列c1，它有100个不同的值。
我打算使用分区索引对列c1上的表进行分区，然后在表上应用数据分区的二级索引。 br />
然后我阅读了关于分区表空间的信息，如何通过创建分区表空间来获得与上面相同的行为？我是否创建了分区表空间，创建了
表然后创建分区索引？
我喜欢分区表空间的属性，因为我正在处理的表的大小
真的很大吗？
Sumath，你在什么平台上？
干杯
Serge
-
Serge Rielau
DB2解决方案开发
IBM多伦多实验室
通过一些文档读取，我相信带有分区表空间
带有C1上的分区条款
工作。然后我可以在每个分区上定义一个有效的二级索引，这个索引是有效的。
什么是作为分区集群创建的索引？
谢谢，
Sumanth
" Sumanth" <苏************ @ sas.com>在消息中写道
新闻：e1 ********** @ foggy.unx.sas.com ...
<我有一个我想要分区的表。它有一个列c1，它有100个不同的值。
我打算使用分区的
索引对列c1上的表进行分区，然后应用数据分区的二级索引表格。
然后我读到了分区表空间，如何通过创建分区表空间来获得与上面相同的行为？我是否创建了分区表空间，创建
表然后创建分区索引？
我喜欢分区表空间的属性，因为我正在处理的表的大小
非常庞大？
任何想法和指示都是适用的。
谢谢，
Sumanth
"萨曼斯" <苏************ @ sas.com>在消息中写道
新闻：e1 ********** @ foggy.unx.sas.com ...
<我有一个我想要分区的表。它有一个列c1，它有100个不同的值。
我打算使用分区的
索引对列c1上的表进行分区，然后应用数据分区的二级索引表格。
然后我读到了分区表空间，如何通过创建分区表空间来获得与上面相同的行为？我是否创建了分区表空间，创建
表然后创建分区索引？
我喜欢分区表空间的属性，因为我正在处理的表的大小
非常庞大？
任何想法和指示都是适用的。
谢谢，
Sumanth
分区表空间仅适用于DB2 for z / OS和OS / 390。如果您使用该平台获得
，请在回复中说明。
Hi,
I have a table that I would like to partition. It has a column c1 which has
100 distinct values.
I was planning to partition the table on column c1 using a partioned index,
and then apply data partitioned secondary indexes on the table.
I then read about partioned table spaces, How do I get the same behaviour as
above by creating
a partioned table space?Do I create the partion table space, create the
table and then create
partioned indexes?
I like the properties of the partioned table space,because the size of the
tables I am dealing with
are really huge?
Any thoughts and pointers are appreaciate.
Thanks,
Sumanth
Sumanth wrote:Hi,
I have a table that I would like to partition. It has a column c1 which has
100 distinct values.
I was planning to partition the table on column c1 using a partioned index,
and then apply data partitioned secondary indexes on the table.
I then read about partioned table spaces, How do I get the same behaviour as
above by creating
a partioned table space?Do I create the partion table space, create the
table and then create
partioned indexes?
I like the properties of the partioned table space,because the size of the
tables I am dealing with
are really huge?
Sumath, what platform are you on?
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
read thru some docs and I believe that going with a partioned table space
with a partition by clause on C1 would
work. I then can define a data partioned secondary index that would be valid
on each of the partitions.
What is an index that is created as a partioned cluster?
Thanks,
Sumanth
"Sumanth" <Su************@sas.com> wrote in message
news:e1**********@foggy.unx.sas.com...Hi,
I have a table that I would like to partition. It has a column c1 which
has 100 distinct values.
I was planning to partition the table on column c1 using a partioned
index,
and then apply data partitioned secondary indexes on the table.
I then read about partioned table spaces, How do I get the same behaviour
as above by creating
a partioned table space?Do I create the partion table space, create the
table and then create
partioned indexes?
I like the properties of the partioned table space,because the size of the
tables I am dealing with
are really huge?
Any thoughts and pointers are appreaciate.
Thanks,
Sumanth
"Sumanth" <Su************@sas.com> wrote in message
news:e1**********@foggy.unx.sas.com...Hi,
I have a table that I would like to partition. It has a column c1 which
has 100 distinct values.
I was planning to partition the table on column c1 using a partioned
index,
and then apply data partitioned secondary indexes on the table.
I then read about partioned table spaces, How do I get the same behaviour
as above by creating
a partioned table space?Do I create the partion table space, create the
table and then create
partioned indexes?
I like the properties of the partioned table space,because the size of the
tables I am dealing with
are really huge?
Any thoughts and pointers are appreaciate.
Thanks,
Sumanth
Partitioned tablespaces are only for DB2 for z/OS and OS/390. If you are
using that platform, please state that in your response.
这篇关于分区表或分区索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
