Then possibly adding it might be in order. You've pretty much said that the access is by date. If you're principal access is by date, but you split it by foreign key, then instead of isolating the reads, you're going to spread them, making them less efficient instead of more efficient.