試卷名稱:114年 - [無官方正解]114 台灣聯合大學系統_學士班轉學生考試試題:計算機概論#137764
年份:114年
科目:研究所、轉學考(插大)、學士後-計算機概論
17. A company's e-commerce database has a "products" table with 10 million rows. A query "SELECT * FROM products WHERE price BETWEEN 100 AND 200" takes 45 seconds. What optimization would provide the most significant performance improvement?
(A) Add more RAM to the database server
(B) Increase the number of CPU cores
(C) Partition the table by product category
(D) Use a faster SSD storage
(E) Create an index on the price column