In MySQL Ok_Packet payload, the Server_Status_flag_enum has SERVER_QUERY_NO_INDEX_USED and SERVER_QUERY_NO_GOOD_INDEX_USED. I want to know when these tow field will return false, and its relationship with EXPLAIN clause. Can someone to figure it out?
That two field seems undocumented and i couldn’t find any doc about this topic.