Get rid of multi-column indexes in database

Components

Labels

Description

We should get rid of multi-column indexes in database or at least create individual indexes for these columns.

Also Price field index is missing in product prices table.

ALTER TABLE `inp_ProductsPricing` ADD INDEX ( `Price` ); not on dev though

Also we could place UNIQUE indexes when appropriate, but not in tables, associated (through unit config) with template, that have "Clone" button on them. Phrase table could be a good start.

Context Information

None

Additional information (do not use)

None

Activity

Details

Priority

Assignee

Reporter

External issue ID

External issue URL

Story Points

Affects versions

Patch Instructions

Patches must be submitted through Phabricator.

Created March 27, 2010 at 10:42 PM
Updated September 6, 2015 at 7:12 AM