views? I understand that ax basically creates SQL views in the database but
I was wondering if say I join inventrans and inventdim in a view and want to
filter by warehouse and a specific item number, will the view first filter
by item number or will the view return all joins and then filter?
I know this is might be a bit of a black box question given that the DBMS
can do what it likes but I would like to get any insight (esp for MS SQL
2000) as I am tempted to use views for some customer requirements but do not
know in a few years whether it will become too slow to use once the number
of transactions grow...
THanks
James
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
