> sebaliknya. Plan yg terbaik menurut saya yaitu tanpa plan.
wahh.. ini saya nggak ngerti. plan terbaik yaitu tanpa plan...
kalo hidup seperti ini.......
untungnya kita membicarakan tentang optimizer-nya RDBMS.
dari DBAZine.com saya dapat seperti ini
--Start Quote
A join's WHERE clause can reduce the number of rows to be processed.
The inner select of a subselect frequently qualifies a number of rows
that are written to a temporary work area before processing of the
outer select can begin. In contrast, a join can process one row from
each of the tables to be joined and return them immediately to the
program without processing perhaps a large number of rows from the
inner select in an intermediate work area.
--End Quote
dan
--Star Quote
If a subselect is automatically transformed into a join, the access
path can differ from that chosen when the join is explicitly coded. In
most cases, it is best to code the join. It much clearer to the next
person looking at the code to determine what is happening.
--end Quote
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Delphindo/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
