数据库单选难度 3真题改编 · 2025
127. 某商品表products存在联合索引idx_category_price_sales(category, price, sales),表结构为(id INT PRIMARY KEY, category INT, price DECIMAL, sales INT, name VARCHAR(100))。执行查询SELECT name FROM products WHERE category = 5 AND price > 1000 ORDER BY sales;时,MySQL 优化器选择的执行计划最可能为()
1000 ORDER BY sales;时,MySQL 优化器选择的执行计划最可能为"},"attribs":{"0":"*0+4*0*1*2+8*0+6*0*1*2+1c*0+5*0*1*2+27*0+5*0*1*2+25*0+m"}},"apool":{"numToAttrib":{"0":["author","7418401374654660611"],"1":["inlineCode","true"],"2":["textHighlightBackground","rgb(242,243,245)"]},"nextNum":3}},"type":"text","referenceRecordMap":{},"extra":{"channel":"saas","isEqualBlockSelection":false,"pasteRandomId":"53f6eff2-1a55-48a9-8c6b-44ef4bba02b1","mention_page_title":{},"external_mention_url":{}},"isKeepQuoteContainer":false,"isFromCode":false,"selection":[{"id":87,"type":"text","selection":{"start":0,"end":254},"recordId":"MEZidQuZNoAqZrxvww3cbqEnnOf"}],"payloadMap":{},"isCut":false}" data-lark-record-format="docx/text" class="lark-record-clipboard">
练习本题 ›