View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0011487 | mantisbt | sql | public | 2010-02-10 06:23 | 2010-02-22 14:34 |
Reporter | atrol | Assigned To | dhx | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 1.2.0rc2 | ||||
Target Version | 1.2.0 | Fixed in Version | 1.2.0 | ||
Summary | 0011487: Unnecessary Index in Database Model | ||||
Description | The index idx_email_id on column email_id of table mantis_email_table can be removed. | ||||
Tags | No tags attached. | ||||
MantisBT: master-1.2.x 3a234243 2010-02-18 10:44 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 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 |