Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Oh, and it becomes painfully obvious why MySQL cannot use more than one index while executing the query.


It has been able to use more than one index per table since MySQL 5.0 (2005):

https://dev.mysql.com/doc/refman/5.7/en/index-merge-optimiza...


Can PostgreSQL use more than one index per table while executing a query?



one index per table

(Sorry for being pedantic)




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: