8-4-2. 상황에 따른 인덱스 선택

-- [SQL-8-4-2-a] SELECT t1.mbr_id ,t1.nick_nm ,t1.join_dtm ,t2.ord_ymd ,t2.ord_amt FROM startdbpg.ms_mbr_big t1 INNER JOIN startdbpg.tr_ord_big t2 ON (t1.mbr_id = t2.mbr_id) WHERE t1.nick_nm LIKE 'Air%' AND t2.ord_ymd = '20241221';