I am having a hard time understanding how exactly the optimizer works. Looking at the posts it appears others are also confused.
I am running a Query in the vbDemo app which is: Select firstname, lastname from customer where fullname is 'test'
When I go into QB and update the customers first and last name I do not see the changes in the VBDemo app.
I have tried: Select firstname, lastname from customer where fullname is 'test' Select firstname, lastname from customer VERIFIED where fullname is 'test' Select firstname, lastname from customer CALLDIRECT where fullname is 'test' Select firstname, lastname from customer OPTIMIZE where fullname is 'test'
All three of these return the unchanged data.
If I run: Select * from customer where fullname is 'test' and then run: Select firstname, lastname from customer where fullname is 'test' I see the changes? (Note I do not see the changes in the first query Select * ...)
The optimizer is turned on and is set to "The start of every query"
I was under the impression that using the CALLDIRECT | UNOPTIMIZED option would show me the changes immediately.
Thanks in advance |