Hi
Where is the performance hit with having NULL values in indexes. On the creation of the record index, on retrieval, or both ?
Cheers
Billy.
Hi
Where is the performance hit with having NULL values in indexes. On the creation of the record index, on retrieval, or both ?
Cheers
Billy.
I can’t think of a case where there would be a problem on insert. For retrieval, it depends on the query. Have you read High Performance MySQL Second Edition? We talked about it at length there.
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright © 2006 - 2021 Percona LLC. All rights reserved.