表结构:ida intidb intname varchar(20)info text存在SQL:select * from scott where ida=? and idb=?select * from scott where ida=?select * from scott where idb=?存在索引:ind_ida(ida)ind_idb(idb)数据分布:表 1000000 rowsida不同值个数1000idb不同值个数900sql...(more)
db2v11 最多可以创建有32767个分区A partitioned table simplifies the rolling in and rolling out of table data and a partitioned table can contain vastly more data than an ordinary table. You can create a partitioned table with a maximum of 32,767 data...(more)