How to optimize this query if the table has more then 50,000 records per day?

Question

select count(1) total
from Leads
where originaldate = curdate()
and campaign=78;

Answer 1

Think of normalizing it and apply knowledge management