The Display Out Of Stock Configuration Option
is implemented by this index. If you have chosen not to display out of stock products,
then the effect is that a product is not entered into this index.
These tables seem to supply the data for the price index:
| Table | Notes |
|------------------------------------------------+-----------------------|
| catalogindex_price | has data |
| catalog_product_index_price | has data - main table |
| catalog_product_index_price_bundle_idx | no data |
| catalog_product_index_price_bundle_opt_idx | no data |
| catalog_product_index_price_bundle_opt_tmp | no data |
| catalog_product_index_price_bundle_sel_idx | no data |
| catalog_product_index_price_bundle_sel_tmp | no data |
| catalog_product_index_price_bundle_tmp | no data |
| catalog_product_index_price_cfg_opt_agr_idx | no data |
| catalog_product_index_price_cfg_opt_agr_tmp | no data |
| catalog_product_index_price_cfg_opt_idx | no data |
| catalog_product_index_price_cfg_opt_tmp | no data |
| catalog_product_index_price_downlod_idx | no data |
| catalog_product_index_price_downlod_tmp | no data |
| catalog_product_index_price_final_idx | no data |
| catalog_product_index_price_final_tmp | no data |
| catalog_product_index_price_idx | has data |
| catalog_product_index_price_opt_agr_idx | no data |
| catalog_product_index_price_opt_agr_tmp | no data |
| catalog_product_index_price_opt_idx | no data |
| catalog_product_index_price_opt_tmp | no data |
| catalog_product_index_price_tmp | has data |
From looking at query logs, catalog_product_index_price
is the main table, as
it is the only one that is included in any queries when loading a category or
product page. I assume that all the rest of the tables are temporary.