Query performance explanation
User EXPLAIN SELECT DISTINCT p1.post_id FROM wp_6hp6nqm250_postmeta p1 WHERE p1.meta_value LIKE '%test prab%' AND p1.meta_key IN ('_billing_address_index','_shipping_address_index','_entry_ids'); still taking 762988 records into consideration Assistant Let’s break down your query and also explain why it's still scanning **762,988 records**, even with the `DISTINCT`, `IN`, and `LIKE` filters. — ### 🔍 Your Query SELECT DISTINCT p1.post_id FROM […]