There are use cases for executing select statements for maniphest transactions where transactionType = "some:value" . Currently, transactionType is not indexed.
Adding an index would prevent these kind of statements from executing table scans which are extremely slow on this table because it is typically contains tens of thousands of rows.
Are those use cases in the upstream? We don't consider the table schema part of the public API, so if these use cases are purely third-party use cases we're very unlikely to pursue this.
I'd also like this index:
CREATE INDEX dateCreated ON phabricator_maniphest.maniphest_transaction (dateCreated);
I am admittedly querying the tables directly.
My use case is finding all recently resolved tasks,
which seems common enough that there will be a
similar use case in the UI which will need this index.