SQL Practice Logo

SQLPractice Online

Level 7 - ArchitectOutput Prediction Questionsm1 indexing strategy

Output: Which Candidate Is More Index-Friendly

Given: 1) WHERE created_at::date = CURRENT_DATE 2) WHERE created_at >= CURRENT_DATE AND created_at < CURRENT_DATE + INTERVAL '1 day' Which predicate is more index-friendly?