oracle ±íÁ¬½ÓÓëË÷ÒýµÄÎÊÌâ
»·¾³ oracle 8.05 ÓбíA(×Ö¶ÎA1)ºÍ±íB(×Ö¶ÎB1). ×Ö¶ÎA1,B1É϶¼ÓÐË÷Òý. A,B ±íÁª²é sql1 Õâ¸ösql ·Ç³£¿ì 2ÃëµÄÑù×Ó SQL code: select * from A,B where A.A1=B.B1(+) and A1='Öµ1' sql2 Õâ¸ösql Âýµ½ÈÃÈËÎÞ·¨ÈÌÊÜ SQL code: select * from A,B where A.A1=B.B1(+) and B1='Öµ1' ÊDz»ÊÇÍâÁªÒÔºó ±íBµÄË÷Òý²»Æð×÷ÓÃÁË? ÇóÔÒòºÍ½â¾ö·½°¸. ×¢:ÔÚoracle10g ÖвâÊÔÏà²îºÜС,Á½¸ösqlÓï¾ä¶¼·Ç³£¿ì.
8iʹÓõÄÊÇrboµÄÔÒò°É ¿´¿´±Ë´ËµÄÖ´Ðмƻ®¡£ 8.0.5ÀïÃæÓ¦¸ÃÊÇRULE£¬10ÀïÊÇCBO¡£ ÔõôÐÞ¸Ä? select * from A,B where A.A1=B.B1(+) and B1='Öµ1' ûÓÐ×ßË÷Òý ÒýÓà ÔõôÐÞ¸Ä? ÓÃhintÓï¾äÇ¿ÖÆÖ¸¶¨ÓÅ»¯Æ÷ÀàÐÍÒýÓà ÔõôÐÞ¸Ä? ʹÓÃhintÌáʾ£¡Ê¹B1Ç¿ÖÆ×ßË÷Òý£¡ Çó¾ßÌåsql Óï¾ä SQL code: --°´Â¥ÉÏ˵µÄʹÓÃHINTÊÔһϠselect /*+index(A,idx_a1) index(B,idx_b1)*/* from A,B where A.A1=B.B1(+) and B1='Öµ1' ²Î¿¼£º http://school.itzcn.com/special-spid-35.html ÉÏÃæ½²½âµÄ±
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨ ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off cli ......