| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| Table name: table_a, table_b size of both tables: ~500M case 1) select a.feld1, b.field1 from table_a a, table_b b where a.field1 = b.field1 (+) case 2) select a.field1, (select field1 from table_b where field1 = a.field1) col from table_a a Two cases will return same results but the response time of case 2 is much faster than case 1 as I really don't understand why? Also what does Oracle actually do on both case? pls help, thanks. |
![]() |
| Thread Tools | |
| Display Modes | |