Çë½Ì¸öoracleË÷ÒýÎÊÌâ
´´½¨Ò»¸ö±ítablename ÓÐÁ½¸ö×Ö¶Î A ,B ÔÚÕâÁ½¸ö×Ö¶ÎÉϷֱ𴴽¨Ë÷Òý INDEX_A , INDEX_B £¬ÄÇôÎÒÔÚ²éѯ select * from tablename where A=value and B= value 1¡¢ÕâÑùµÄwhere ×Ó¾äÄÜÓõ½A ºÍ B µÄË÷ÒýÂð£¿ÎÒ¾õµÃÓ¦¸ÃÊÇÄÜÓõ½A µÄË÷Òýµ«Óò»µ½B µÄË÷Òý£¿ 2¡¢Èç¹ûÓÐÕâÑùµÄ²éѯÊDz»ÊÇ×îºÃ´´½¨Ò»¸ö ÁªºÏË÷Òý ºÃÒ»µã£¿
ÒýÓà 1, Á½¸öÁÐÉ϶¼ÓÐË÷Òý£¬ÄÇôÕâÖÖÇé¿öÏÂʹÓÃÄĸöË÷ÒýÒª¿´oracleÔõôÅжÏIndex_aºÍindex_bµÄÑ¡ÔñÐÔ£»±ÈÈç˵£¬index_aÊÇΨһË÷Òý£¬¶øBÁд洢µÄÊÇÐÔ±ð×ֶΣ¬¶øÇÒÄã¶Ô±íºÍË÷Òý¶¼½øÐÐÁË·ÖÎö£¬ÄÇôoracle¿Ï¶¨Ê¹ÓÃindex_a£» µ«£¬Â¥Ö÷Äã¿ÉÒÔÇ¿ÖÆoracleÑ¡ÔñÄãÏ£ÍûÆäÖ´ÐеÄË÷Òý£» select /*+ index(a index_b) */ from tablename where a=value and b=value; 2, µ±È»£¬Èç¹ûÄÜ´´½¨Ò»¸öÁªºÏË÷ÒýµÄ»°£¬²¢ÇÒÄãʹÓÃÁËÑ¡ÔñÐԽϺõÄÁÐ×÷Ϊǰµ¼ÁУ¬ÄÇôÁªºÏË÷ÒýÓ¦¸Ã»áÓиüºÃµÄÖ´ÐÐЧÂÊ¡£Ïà·´£¬ÄãÈç¹ûÑ¡ÔñÁËÑ¡ÔñÐԽϲîµÄÁÐ×÷ΪÁËǰµ¼ÁУ¬ÆäЧÂÊ¿ÉÄÜ»¹²»Èçµ¥¸öÁеÄË÷Òý¡£ ͬÒâÒýÓà 1, Á½¸öÁÐÉ϶¼ÓÐË÷Òý£¬ÄÇôÕâÖÖÇé¿öÏÂʹÓÃÄĸöË÷ÒýÒª¿´oracleÔõôÅжÏIndex_aºÍindex_bµÄÑ¡ÔñÐÔ£»±ÈÈç˵£¬index_aÊÇΨһË÷Òý£¬¶øBÁд洢µÄÊÇÐÔ±ð×ֶΣ¬¶øÇÒÄã¶Ô±íºÍË÷Òý¶¼½øÐÐÁË·ÖÎö£¬ÄÇôoracle¿Ï¶¨Ê¹ÓÃindex_a£» µ«£¬Â¥Ö÷Äã¿ÉÒÔÇ¿ÖÆoracleÑ¡ÔñÄãÏ£ÍûÆäÖ´ÐеÄË÷Òý£» select /*+ index(a index_b) */ from tablename where a=value and b=value; 2, µ±È»£¬Èç¹ûÄÜ´´½¨Ò»¸öÁªºÏË÷ÒýµÄ»°£¬²¢ÇÒÄãʹÓÃÁËÑ¡ÔñÐԽϺõÄÁÐ×÷Ϊǰµ¼ÁУ¬ÄÇôÁªºÏË÷ÒýÓ¦¸Ã»áÓиüºÃµÄÖ´ÐÐЧÂÊ¡£Ïà·´£¬ÄãÈç¹ûÑ¡ÔñÁËÑ¡ÔñÐԽϲîµÄÁÐ×÷ΪÁËǰµ¼ÁУ¬ÆäЧÂÊ¿ÉÄÜ»¹
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿ ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ.. ÒýÓà ¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......