table t_image
partition by hash(image_id)
(
partition part_image_1 TABLESPACE fars_data1,
partition part_image_2 TABLESPACE fars_data1
);select rowid,image_id from image PARTITION(part_image_1) where image_id in (8008451,8034871);
一般按理说都是rowid,但是这个语句默认排序怎么是:
rowid id
AAASDOAAJAAAACLAAA 8008451
AAASDOAAFAAAAEAAAA 8034871
partition by hash(image_id)
(
partition part_image_1 TABLESPACE fars_data1,
partition part_image_2 TABLESPACE fars_data1
);select rowid,image_id from image PARTITION(part_image_1) where image_id in (8008451,8034871);
一般按理说都是rowid,但是这个语句默认排序怎么是:
rowid id
AAASDOAAJAAAACLAAA 8008451
AAASDOAAFAAAAEAAAA 8034871
rowid由 数据库段(6)+数据文件号3+数据块号6+块行号3
rowid 大小不表示数据顺序,而且你还是hash分区
哪位大侠明确赐教下小弟吧