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]

  Should I index every field, to make my queries 100% optimizable?:

  No.  It is not necessary, nor practical, to index every field in your
  database, to achieve high performance queries.  Create indexes on fields
  that are generally used the most for reporting.  For example, if you TOTAL
  invoices for a specific date range, say each week, or month, then maintain
  an index on that date.  Keep in mind that you want your indexes, to
  produce the smallest set of records to be visited by Mach SIx to test the
  non-indexed portion of the query.  You should be able to achieve this
  goal, without reproducing the majority of your database in indexes.


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