如下建表语句CREATE TABLE datapartT (a int, b int,primary key(a) )IN TbspT INDEX IN TbspXPARTITION BY ( a,b ) ( PARTITION Part0 STARTING (0, 0) ENDING (0, 10)IN TbspD,PARTITION Part1 ENDING (20,20)INDEX IN TbspY,PARTITION Part2 ENDING (40,40)INDEX IN...
显示全部如下建表语句
CREATE TABLE datapartT (a int, b int,primary key(a) )IN TbspT INDEX IN TbspXPARTITION BY ( a,b )
(
PARTITION Part0 STARTING (0, 0) ENDING (0, 10)IN TbspD,
PARTITION Part1 ENDING (20,20)INDEX IN TbspY,
PARTITION Part2 ENDING (40,40)INDEX IN TbspW,
PARTITION Part3 STARTING (100,100) ENDING (150, 150)
INDEX IN TbspW,PARTITION Part4 ENDING (200, 200) );
因为我指定了主键索引表空间为TbspXpartition,若没有声明,它默认会在哪个表空间?
表上的index in 表空间,与分区里面的index in 又有什么区别呢?
收起