DDieterich / DTGen

DTGEN Code Generation Tool for Relational Designers (See Wiki Branch)
http://dtgen.org
3 stars 0 forks source link

Reduction of Redundant Indexes #11

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What will the enhancement do?

   Reduce the number of redundant indexes.  For instance, the FILE_LINES table has a foreign key index that is a sub-set of its natural key index.  The foreign key index slows inserts and deletes without any benefit.

How is this currently done or handled?

   Inserts and deletes are slow.

What version of the product are you using? On what operating system?

   Not yet released

Please provide any additional information below.

Original issue reported on code.google.com by Duane.Di...@gmail.com on 6 Sep 2011 at 9:25

GoogleCodeExporter commented 9 years ago

Original comment by Duane.Di...@gmail.com on 6 Sep 2011 at 9:26

GoogleCodeExporter commented 9 years ago
Changed to defect because it is included functionality that potentially slows 
down application performance.

Original comment by Duane.Di...@gmail.com on 4 Apr 2012 at 1:59

GoogleCodeExporter commented 9 years ago

Original comment by Duane.Di...@gmail.com on 9 Jul 2012 at 11:07

GoogleCodeExporter commented 9 years ago

Original comment by Duane.Di...@gmail.com on 26 Jul 2012 at 1:15