Project:
View Revisions: Issue #23549 | [ All Revisions ] [ Back to Issue ] | ||
Summary | 0023549: Somo Missing indexes | ||
Revision | 2013-04-15 13:26 by egoitz | ||
Description | There are some indexes that should be created. create INDEX AD_ALERT_RULE ON AD_ALERT USING btree (AD_ALERTRULE_ID); CREATE INDEX M_PRODUCT_UOM_PRODUCT ON M_PRODUCT_UOM USING btree (M_PRODUCT_ID); CREATE INDEX AD_PROCESS_RUN_STATUS ON AD_PROCESS_RUN USING btree (STATUS); CREATE INDEX m_storage_detail_PRODUCT ON m_storage_detail USING btree (m_product_id); |
||
Revision | 2013-04-15 13:16 by egoitz | ||
Description | There are some indexes that should be created. create INDEX AD_ALERT_RULE ON AD_ALERT USING btree (AD_ALERTRULE_ID); CREATE INDEX M_PRODUCT_UOM_PRODUCT ON M_PRODUCT_UOM USING btree (M_PRODUCT_ID); CREATE INDEX AD_PROCESS_RUN_STATUS ON AD_PROCESS_RUN USING btree (STATUS); CREATE INDEX m_storage_detail_PRODUCT ON m_storage_detail USING btree (m_locator_id); |
||
Revision | 2013-04-15 13:11 by egoitz | ||
Description | There are some indexes that should be created. create INDEX AD_ALERT_RULE ON AD_ALERT USING btree (AD_ALERTRULE_ID); CREATE INDEX M_PRODUCT_UOM_PRODUCT ON M_PRODUCT_UOM USING btree (M_PRODUCT_ID); CREATE INDEX AD_PROCESS_RUN_STATUS ON AD_PROCESS_RUN USING btree (STATUS); |
Copyright © 2000 - 2009 MantisBT Group |