Without indexing, Magento would have to calculate the price of every product on the fly—taking into account shopping cart price rules, bundle pricing, discounts, tier pricing, and so on. Loading the price for a product would take a long time, possibly resulting in cart abandonment.

Using the Index Management Page

1. To understand how indexing works and to re-index when necessary, you must log into the Admin Panel as an administrator.

2. Navigate to System > Index Management menu:

3. The following page displays the list of Indexes with their descriptions:

Note: the page displays differently if you enabled the flat catalog options, because attributes are stored in many tables—and that includes copies of some of the same attributes--SQL queries are long and complex. The flat catalog feature creates new tables on the fly, where each row contains all necessary data about a product or category. That is why we recommend to enable the following option.

Go to System > Configuration > Catalog > Catalog and expand Fontend section.

5. Find Use Flat Catalog Category and Use Flat Catalog Category lists options and set them to Yes. Click Save Config button in the top right corner:

6. To inform you that one or more indexers must be rebuilt, a message banner similar to the following displays in the Admin Panel.

7. When you’re notified that indexes must be rebuilt, go back to System->Index management.

8. o update one index only, click the Reindex Data link in the Action column on the right. To update more than one indexer at a time, select the check box next to its name. From the Action list, click Reindex Data and click Submit:

9. Please, wait until the re-indexing is completed. Now your indexes are up-to-date.

That is the end of the tutorial. Now you know how to re-index data and in what cases it is needed in Magento.