oracle表分析analyze，oracle数据库的数据统计(analyze)（Data statistics of Oracle database (analyze)）.docVIP

 oracle数据库的数据统计（analyze）（DatastatisticsofOracle database (analyze)) Datastatistics of Oracledatabase(Analyze) The Oracle data optimizer are two optimization methods: price /costbased optimizer(CBO)and rulebased optimizer(RBO), optimizethe system time of SQL in,what kind of optimization depends on the initialization parameterOPTIMIZER MODE,the parameter values can be set to: CHOOSE, RULE, ALL ROwWS, FIRST ROwS.In the later version of Oracle9i, a new optimization parameter command isintroduced:FIRSTROwS1 FIRSTROWS10,FIRSTROWS10O,FIRSTROWS1000.(specific instructions will be introduced in the fu