Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracle·ÖÎö±íºÍË÷Òý(analyze)

analyze table tablename compute statistics;
analyze index indexname compute statistics;
¶ÔÓÚʹÓÃCBOºÜÓкô¦£¬¿ÉÒÔʹÓøü¿É¿¿µÄtableÐÅÏ¢£¬´Ó¶øÖ´Ðмƻ®Ò²¿ÉÒÔ¸ü׼ȷһЩ£¬ÔÚ10g»á×Ô¶¯analyze£¬Ö®Ç°µÄ°æ±¾ÐèÒªÊÖ¶¯¶¨ÆÚ
Éú³Éͳ¼ÆÐÅÏ¢,,Ñ¡ÔñºÏÀíµÄÖ´Ðмƻ®..
OracleµÄonline documentÕâÑùÃèÊöanalyzeµÄ×÷Óãº
Use the ANALYZE statement to collect non-optimizer statistics, for example, to:
1¡¢Collect or delete statistics about an index or index partition, table or table partition, index-organized table, cluster, or scalar object attribute.
2¡¢Validate the structure of an index or index partition, table or table partition, index-organized table, cluster, or object reference (REF).
3¡¢Identify migrated and chained rows of a table or cluster.
¶ÔÓÚÊÕ¼¯Í³¼ÆÐÅÏ¢Õâ¿é£¬ÎÒÒ»°ãʹÓÃdbms_statsÕâ¸öpackage£¬ÊÕ¼¯Í³¼ÆÐÅÏ¢µÄ×öÓÃʹCBO·½Ê½µÄÓÅ»¯Ñ¡ÔñÖ´Ðмƻ®¸ü׼ȷ¡£
ͳ¼ÆÐÅÏ¢×îºÃ¶¨ÆÚÊÕ¼¯£¬ÒÔÒµÎñµÄ²»Í¬È·¶¨²»Í¬µÄÊÕ¼¯ÖÜÆÚ¡£


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

ÅäÖöà¸öSDE·þÎñ(oracle)

ÅäÖöà¸öSDE·þÎñ(oracle)  ÏîĿҪ׼±¸Á½·ÝÏàͬ½á¹¹µÄÊý¾Ý¸ø²»Í¬µÄÓû§£¬ÓÉÓÚÊý¾ÝÁ¿ºÜ´ó£¬²»¶ÏµÄ±¸·Ý»¹Ô­Ð§ÂÊÊ®·ÖµÍÏ£¬Òò´Ë¿¼ÂÇн¨Ò»¸öÊý¾Ý¿â£¬½¨Á¢Á½¸öSDE·þÎñ¡£
1.н¨Êý¾Ý¿âDXGX_GX(Ô­Êý¾Ý¿â£ºDXGX)
2.ÔËÐÐSDE POST д´½¨Ò»¸ö·þÎñ£¨ÔÚ´´½¨Ö®Ç°ÐèÒªÏȹرÕÒÑÔÚÔËÐÐÖеÄSDE·þÎñ£©
3.ÔÚArcCatalogÀィÁ¢ÐµÄSDEÁ¬ ......

ͿĨOracle——Èý˼±Ê¼ÇÖ®Ò»²½Ò»²½Ñ§Oracle

¡¡¡¡
¡¡¡¡±¾Êé×÷Ϊһ±¾´´×÷Ö®³õ¾Í¶¨Î»ÓÚ¼¼ÊõÓ¦ÓõÄʵ¼ù²Î¿¼Ê飬ËäȻǰǰºóºó´®ÁªÁËOracleÊý¾Ý¿âÖÐÊ®Óà¸ö³£ÓÃÌØÐÔ»ò¹¤¾ß£¬µ«ÔÚÕ½ڵÄÉè¼ÆÉÏÍêÈ«×ñÑ­ÕâÒ»ÀíÄî¡£ÔÚÉæ¼°ÌØÐÔ»ò¹¤¾ßÓ¦ÓõÄÿһ¸öÕ½ڣ¬¾ùÓÐÏà¹ØʵÀýÑÝʾÈçºÎÓ¦Óã¬ËùÓÐʾÀýµÄ×îÖÕÄ¿µÄ£¬¾ÍÊÇÏ£ÍûÔĶÁ±¾ÊéµÄÅóÓÑ£¬Äܹ»½«Ë«ÊÖ½â·Å³öÀ´£¬×ÔÐÅÁé»îµØʹÓÃÊéÖнéÉܵĸ÷Ï ......

Oracle×Ö·û¼¯²âÊÔ

ÒÔÏ»شðÊôÓÚתÔØ£º
¾­³£¿´µ½Ò»Ð©ÅóÓÑÎÊORACLE×Ö·û¼¯·½ÃæµÄÎÊÌ⣬ÎÒÏëÒÔµü´úµÄ·½Ê½À´½éÉÜһϡ£
µÚÒ»´Îµü´ú£ºÕÆÎÕ×Ö·û¼¯·½ÃæµÄ»ù±¾¸ÅÄî¡£
ÓÐЩÅóÓÑ¿ÉÄÜ»áÈÏΪÕâÊǶà´ËÒ»¾Ù£¬µ«Êµ¼ÊÉÏÕýÊÇÓÉÓÚ¶ÔÏà¹Ø»ù±¾¸ÅÄî°ÑÎÕ²»Ç壬²Åµ¼ÖÂÁËÖî¶àÎÊÌâºÍÒÉÎÊ¡£
Ê×ÏÈÊÇ×Ö·û¼¯µÄ¸ÅÄî¡£
ÎÒÃÇÖªµÀ£¬µç×Ó¼ÆËã»ú×î³õÊÇÓÃÀ´½øÐпÆѧ¼ÆËãµÄ£¨Ë ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ