Forum Post: RE: Got asked a Newbie Question: Nested -vs- Join

  • Thread starter Thread starter ke@iap.de
  • Start date Start date
Status
Not open for further replies.
K

ke@iap.de

Guest
When you test, you must at minimum restart DB or better reboot between tests, otherwise OS (and may be DB caching) will have big impact. Second: Take a bigger test where test time is about a few seconds, the time measurement in OE is not too exact. Third: The nest is not the biggest issue. Much bigger is the break by, where OE needs to hold two records to compare. When you remove the break by and use variables to detect the change, then that should make a difference. my 2 cent :) Klaus

Continue reading...
 
Status
Not open for further replies.
Back
Top