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

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
ÉÏÃæ½²½âµÄ±


Ïà¹ØÎÊ´ð£º

linuxÏÂCÓïÑÔ¿ª·¢oracleµÄÎÊÌâ¡£

Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â 
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

eclipseÖÐÁ¬½Ó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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ