View Issue Details

IDProjectCategoryView StatusLast Update
0011487mantisbtsqlpublic2010-02-22 14:34
Reporteratrol Assigned Todhx  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version1.2.0rc2 
Target Version1.2.0Fixed in Version1.2.0 
Summary0011487: Unnecessary Index in Database Model
Description

The index idx_email_id on column email_id of table mantis_email_table can be removed.
email_id is already primary key

TagsNo tags attached.

Activities

atrol

atrol

2010-02-10 06:27

developer   ~0024363

seems also to be related to 0007644

dhx

dhx

2010-02-18 10:50

reporter   ~0024425

Thanks atrol, I've removed the index in both the 1.2.x and 1.3.x branches!

Related Changesets

MantisBT: master-1.2.x 3a234243

2010-02-18 10:44

dhx


Details Diff
Fix 0011487: Remove idx_email_id index on mantis_email_table

The idx_email_id index on mantis_email_table is not necessary as it only
covers the email_id column. The email_id column happens to be the
primary key of the table and thus doesn't need another index (the
primary key is already an index).
Affected Issues
0011487
mod - admin/schema.php Diff File

MantisBT: master b6951823

2010-02-18 10:44

dhx


Details Diff
Fix 0011487: Remove idx_email_id index on mantis_email_table

The idx_email_id index on mantis_email_table is not necessary as it only
covers the email_id column. The email_id column happens to be the
primary key of the table and thus doesn't need another index (the
primary key is already an index).
Affected Issues
0011487
mod - admin/schema.php Diff File