- Issue 1: The less optimum index from the base class is used instead of the more optimum index on the inherited class, making it inefficient with many records.
- Issue 2: #3624 The index used in the query is chosen based on the order in which it was created. In addition, it does not use multiple indexes to satisfy the query, making it inefficient with many records.
- Issue 3: #3611 Using a fulltext index at the same time as another index does not work. Therefore you must use subqueries to limit the result, which is very inefficient when there are many records.
- Issue 4: #3462 Doing a COUNT(*) in sql uses the index, but still reads every record, instead of just issuing the count on the index.
- Issue 5: #3622 Doing a COUNT(fieldname) in