3 ms·
You are correct, I missed that. In MySQL, functional indices are implemented as invisible generated virtual columns (and there is no vector index type supported
by sgarland 2y ago
You are correct, I missed that. In MySQL, functional indices are implemented as invisible generated virtual columns (and there is no vector index type supported yet that I'm aware of), but Postgres has a more capable approach.
- charettes 2y agoTIL I wasn't aware MySQL functional indices were implemented using virtual columns [0] [0] https://dev.mysql.com/doc/refman/8.4/en/create-index.html#create-index-functional-key-parts https://dev.mysql.com/doc/refman/8.4/en/create-index.html#cr...