创建对象droptablea0001;createtablea0001asselect*fromdba_objects;createtablea0002asselect*fromdba_objectswhere1=2;createindexiOBJECT_IDona0001(OBJECT_ID)createindexiCREATEDona0001(CREATED)收集统计信息begindbms_stats.g