1、收集统计信息
Command> statsupdate;
2、查看表的信息
Command> select b.tblname,a.tblid,a.sys1,a.numtups,a.laststatsupdate from tbl_stats a, tables b where a.tblid=b.tblid and a.numtups>0 order by a.numtups;
< TEST , 293865696, 0, 1, Thu Jun 21 21:37:48 2012 >
< USERINFO , 293865568, 0, 1, Thu Jun 21 21:37:48 2012 >
< SERVICEFEETYPE , 293865552, 0, 1, Thu Jun 21 21:37:48 2012 >
< CARDSTATE , 293865024, 0, 3, Thu Jun 21 21:37:48 2012 >
< REGISTRYSTATE , 293865504, 0, 4, Thu Jun 21 21:37:48 2012 >
< NAMINGSTATE , 293865392, 0, 6, Thu Jun 21 21:37:48 2012 >
< REGISTRYTYPE , 293865520, 0, 6, Thu Jun 21 21:37:48 2012 >
< CARDMONEYTYPE , 293865008, 0, 11, Thu Jun 21 21:37:48 2012 >
< ENTERPRISETYPE , 293865232, 0, 16, Thu Jun 21 21:37:48 2012 >
< MOBILEFAILURETYPE , 293865248, 0, 17, Thu Jun 21 21:37:48 2012 >
< CNROUTETYPE , 293865136, 0, 27, Thu Jun 21 21:37:48 2012 >
< CNNROUTETYPE , 293866160, 0, 30, Thu Jun 21 21:37:49 2012 >
< CUROUTETYPE , 293865120, 0, 33, Thu Jun 21 21:37:48 2012 >
< EUCPSYSLOGEVENT , 293865184, 0, 34, Thu Jun 21 21:37:48 2012 >
< SMSSTANDBYROUTE , 293865888, 0, 125, Thu Jun 21 21:37:49 2012 >
< CMROUTETYPE , 293865104, 0, 163, Thu Jun 21 21:37:48 2012 >
< MOBILETYPE , 293865264, 0, 252, Thu Jun 21 21:37:48 2012 >
< MT , 330754728, 0, 420, Thu Jun 21 21:37:49 2012 >
< BLACKDICT , 293865168, 0, 1928, Thu Jun 21 21:37:48 2012 >
< MT_LOG_CACHE , 330754840, 0, 2716, Thu Jun 21 21:37:49 2012 >
< BLACKLIST , 293865856, 0, 559410, Thu Jun 21 21:37:49 2012 >
21 rows found.
Command>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12355989/viewspace-733598/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12355989/viewspace-733598/