Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
ÉÏÃæ½²½âµÄ±


Ïà¹ØÎÊ´ð£º

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

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

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

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

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ