Project:
| 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 |
 |