Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

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
Powered by Mantis Bugtracker