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