Hacker News new | ask | show | jobs
by anton_gogolev 3290 days ago
Oh, and it becomes painfully obvious why MySQL cannot use more than one index while executing the query.
3 comments
morgo 3290 days ago
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...

link
hoschicz 3290 days ago
Can PostgreSQL use more than one index per table while executing a query?
link
anton_gogolev 3290 days ago
Absolutely: https://www.postgresql.org/docs/8.3/static/indexes-bitmap-sc...
link
sfilargi 3290 days ago
one index per table

(Sorry for being pedantic)

link