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]

  What is query optimization?:

  Query optimization is the process of finding the best way to find a set
  of records in a database meeting a search criteria.   Mach SIx optimizes
  queries by first searching the index files, for every index key expression
  found in the FOR condition of a query.   This step produces a set of
  records, in most cases, many times smaller than the original table to
  visit and test the remaining non-indexed portion of the query.  Fully
  indexed queries, in some cases, can be satisfied directly from the index
  files.  The result, is maximum query efficiency and throughput when
  targetting a subset of data in a large database file.



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