from 
JoeUser Forums
JoeUser Forums
Don't over use and don't under-use indexing.
Indexing is used for common searches. This includes searches performed by user, or by a program, to link records together.
If it is necessary to find customer information quickly, index the fields. This allows quick retrieval of the information. Know the types of information requiring fast retrieval.
Intranet solutions Inventory Software Asset tracking software information management report viewer
Think of common, everyday, tasks requiring fast interaction. These are fields to index. Do not index a birthday or salutation field. Index a last name, or date field.
Date fields are common query fields for reporting on daily activities. Determine what are the main fields you need to do business on a hour by hour, or minute by minute, basis and index them.
Indexing is used for common searches. This includes searches performed by user, or by a program, to link records together.
If it is necessary to find customer information quickly, index the fields. This allows quick retrieval of the information. Know the types of information requiring fast retrieval.
Intranet solutions Inventory Software Asset tracking software information management report viewer
Think of common, everyday, tasks requiring fast interaction. These are fields to index. Do not index a birthday or salutation field. Index a last name, or date field.
Date fields are common query fields for reporting on daily activities. Determine what are the main fields you need to do business on a hour by hour, or minute by minute, basis and index them.
WinCustomize Forums
