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

View Revisions: Issue #35267 Back to Issue ]
Summary 0035267: Some indexes can be improved
Revision 2017-04-06 18:01 by marvintm
Description Some indexes in the Retail distribution and other modules affect columns which in many cases have a significant amount of null values.

These indexes could be improved so that only the not null records are included. This shouldn't impact the queries executed against these tables, and will significantly reduce the size of the index. The only downside is that the update to this release may be a bit slower due to some indexes having to be recreated.

More info can be found here: http://wiki.openbravo.com/wiki/Constraints_and_Triggers#Partial_indexes [^]
Revision 2017-03-06 13:21 by marvintm
Description Some indexes in the Retail distribution and other modules affect columns which in many cases have a significant amount of null values.

These indexes could be improved so that only the not null records are included. This shouldn't impact the queries executed against these tables, and will significantly reduce the size of the index.


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker