[DDC-1413] Automatically create index for discriminator column Created: 11/Oct/11 Updated: 12/Jun/13
|Project:||Doctrine 2 - ORM|
|Reporter:||A.J. Brown||Assignee:||Benjamin Eberlei|
It would be nice if the command line orm schema-tool would suggest an index on the discriminator column for single inheritance tables. Since that column would almost always be in the query, I can't think of a case when you wouldn't want it to be in an index
|Comment by Menno Holtkamp [ 12/Jun/13 ]|
This topic suggests it is a bad practice though:
In case of a big STI hierarchy, this might become usefull, additional testing required. However, as soons as a STI hierarchy becomes big, Class Table Inheritance might be more appropriate...