order by piece; exit; EOF 然后,我们只要在OS环境下如下执行即可 $./whoit.sh Spid [Q]怎么样分析表或索引 [A]命令行方式可以采用analyze命令 如Analyze table tablename compute statistics; Analyze index indexname estimate statistics; ANALYZE TABLE tablename COMPUTE STATISTICS FOR TABLE FOR ALL COLUMNS ...