When executing the first alternate sql for the first time, the table is being read and the data is stored in the database buffers. When the second alternate sql is being run, the results would actually be faster, as it does not have to read the table but rather directly from the database buffers. Workaround is to actually run the alternate sql a few times to average the results so that we can determine which alternate sql is better. Is this true?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center