Index is defined as to categorize or list, or to make adjustments automatically based on a particular changing statistic. An example of index is to put employees names in alphabetical order.
Indexing is one of the most important database features and must be implemented properly where needed to improve response time. Just like in other database-based applications, creating an index must be dealt with carefully, and only the fields that will be looked up often must be indexed. Indexing will not just improve the response time; it also greatly improves the database performance and can help optimize slow queries
Index is defined as to categorize or list, or to make adjustments automatically based on a particular changing statistic. An example of index is to put employees names in alphabetical order.
Indexing is one of the most important database features and must be implemented properly where needed to improve response time. Just like in other database-based applications, creating an index must be dealt with carefully, and only the fields that will be looked up often must be indexed. Indexing will not just improve the response time; it also greatly improves the database performance and can help optimize slow queries
