Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- Mach SIx v1.1c - Reference Guide - Norton Guide http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]

  Smart Translations:

  In some cases Mach SIx can translate a non-indexed expression into one
  that can be optimized.  The table below shows exactly when a smart
  translation could be used to optimize what would seem to be a non-indexed
  expression.  The first column shows the expression as it would appear in
  the FOR condition.  The second column lists the possible index keys that
  could be used to optimize the first expression.  As long as you have an
  index built on the translation (the second column), the expression in the
  first column is optimizable.  One final note,  Mach SIx will only
  translate keys listed to the left of the relational operator.

                                Optimized using
      Expression                index key
      -----------               ---------------

      empty( Last )             Last

      year( Date )              dtos( Date )
                                Date

      Last = "HEW"              upper( Last )



Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson