Slide 23
Slide 23 text
複合インデックス
CREATE INDEX `users_idx1`
ON `users` (`created_at`, `updated_at`);
SELECT * FROM `users`
ORDER BY `created_at`, `updated_at`;
SELECT * FROM `users`
ORDER BY `created_at`;
SELECT * FROM `users`
ORDER BY `updated_at`, `created_at`;
⭕
⭕
❌