4 ms·
Oh, and it becomes painfully obvious why MySQL cannot use more than one index while executing the query.
by anton_gogolev 9y ago
Oh, and it becomes painfully obvious why MySQL cannot use more than one index while executing the query.
- sfilargi 9y agoone index per table (Sorry for being pedantic)
- hoschicz 9y agoCan PostgreSQL use more than one index per table while executing a query?
- anton_gogolev 9y agoAbsolutely: https://www.postgresql.org/docs/8.3/static/indexes-bitmap-scans.html https://www.postgresql.org/docs/8.3/static/indexes-bitmap-sc...
- deleted 9y ago[deleted]
- morgo 9y agoIt 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-optimization.html https://dev.mysql.com/doc/refman/5.7/en/index-merge-optimiza...