declare
v_ddl varchar(1024);
v_used_bytes number;
v_alloc_bytes number;
begin
dbms_space.create_index_cost(
ddl =>' create index deal_ind_global on deal(dealtype,orderseqid)
GLOBAL PARTITION BY hash(dealtype) partitions 12 ',used_bytes=>v_used_bytes,alloc_bytes =>v_alloc_bytes);
dbms_output.put_line('used_bytes='||v_used_bytes/1024/1024||' MB'||' alloc_bytes='|| v_alloc_bytes/1024/1024 || ' MB');
end;
/
估算创建的索引的大小
最新推荐文章于 2022-07-27 14:37:07 发布