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 ÉÏÃæ½²½âµÄ±
Ïà¹ØÎÊ´ð£º
Á½¸öÎļþ1.PC£¬1.inc 1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
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 ......