求优化一句SQL

Question

SELECT artwork_transactions.id, artwork_transactions.artwork_id, artwork_transactions.transaction_date, artwork_transactions.trans_type, artwork_transactions.display_price, artwork_transactions.icon_img_url FROM artwork_transactions INNER JOIN artworks ON artwork_transactions.artwork_id = artworks.id WHERE artworks.artist_id = 28896 ORDER BY artwork_transactions.transaction_date ASC LIMIT 25 OFFSET 0

这么一句SQL，artworks和artwork_transactions表都是200万上下的表。求优化思路？

Answer 1

200万不是很大

1、检查下索引是否建立正确
2、如果这个数据经常使用，memcache把它缓存起来吧