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.