Copy this code into a job. Enable database trace.
Execute this statement with force_placeholders and then with force_literals. What difference do you see? Take a closer look at where statement (i.e. where inventdim.inventlocationid = )
Regards
Harry
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of anton_tjiptadi
Sent: 5. juni 2006 06:32
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Select statement
Hi guys,
I found one of select statement using key "with nested_loop"
and "force_placeholder"
can anyone tell me what it's means ?
//SELECT WITH NESTED_LOOP, FORCE_PLACEHOLDERS * FROM InventDim...
many thanks,
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course | Business to business finance | Small business finance |
Business finance consultant | Business finance magazine | Business finance schools |
YAHOO! GROUPS LINKS
- Visit your group "Axapta-Knowledge-Village" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.