sqlËÙ¶ÈÂýµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

select a.exec_sqn, a.dept_code 
  from ipmonmex a, lis_test_reg b 
where a.exec_sqn = b.exec_sqn 
  and b.barcode = '1002052716' 

Ö´ÐÐËٶȵÄ2·ÖÖÓ×óÓÒ£¬ÊµÔÚÊÇÌ«ÂýÁË£¬µ«ÊÇÒ²ÊÇÓõ½ÁËË÷Òý£¬a.exec_sqnÊÇΨһË÷Òý£¬b.exec_sqnÊÇÆÕͨË÷Òý¡£ 

Ö´Ðмƻ®ÈçÏ 

SELECT STATEMENT, GOAL = CHOOSE ºÄ·Ñ=1267 »ùÊý=77072 ×Ö½Ú=4084816 
MERGE JOIN ºÄ·Ñ=1267 »ùÊý=77072 ×Ö½Ú=4084816 
  TABLE ACCESS BY GLOBAL INDEX ROWID ¶ÔÏóËùÓÐÕß=TLHIS ¶ÔÏóÃû³Æ=IPMONMEX ºÄ·Ñ=826 »ùÊý=7707246 ×Ö½Ú=107901444 
  INDEX FULL SCAN ¶ÔÏóËùÓÐÕß=TLHIS ¶ÔÏóÃû³Æ=PK_IPMONMEX ºÄ·Ñ=26 »ùÊý=7707246 
  SORT JOIN ºÄ·Ñ=441 »ùÊý=63901 ×Ö½Ú=2492139 
  INDEX RANGE SCAN ¶ÔÏóËùÓÐÕß=TLHIS ¶ÔÏóÃû³Æ=LIS ºÄ·Ñ=2 »ùÊý=63901 ×Ö½Ú=2492139

---

select a.exec_sqn, a.dept_code 
  from ipmonmex a, lis_test_reg b 
where a.exec_sqn = b.exec_sqn 
  and b.barcode = '1002052716' 

¾ÍÕâôһ¾äÒªÁ½·ÖÖÓ?

ÄÇ·Ö±ð¶Ôipmonmex , lis_test_reg ±íµÄexec_sqn Áн¨Á¢Ë÷Òý.

Èç¹û»¹²»ÐÐ,¶Ôlis_test_reg µÄ barcode ÁÐÔÙÁ¬½ÓË÷Òý.

---

2ÕűíÓжà´óÄØ£¿ 

Oracle SQLµÄÓÅ»¯ ¹©²Î¿¼..
http://blog.csdn.net/tianlesoftware/archive/2009/10/15/4672023.aspx


------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
Í