where is the performance hit with null values in indexes?


Where is the performance hit with having NULL values in indexes. On the creation of the record index, on retrieval, or both ?



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.