AnsweredAssumed Answered

best use of field indexing

Question asked by c.wagner1 on Feb 28, 2011
Latest reply on Mar 1, 2011 by philmodjunk


best use of field indexing


I have never really understood the best use of field indexing other then setting a field indexing to "Full" increases the speed of finds and look ups at the expense of disk space.  In today's world of inexpensive disk storage is their any reason not to turn indexing on for every field in a solution?

In a simple invoicing database example with a table for inventory and sales_orders where the field itemNumber is the key field between the 2 tables and sales_orders::quantity, sales_orders::price, and sales_orders::itemDecription are all look-ups from the inventory table what fields are the best to have indexing on?