Execution time is more how to overcome

Question

My Project in MVC DB context.

 

 

I have 10000 records in one table som another table 3 or 4 table-use n I want data display on Date data type basis but Execiteion time is so much required how to overcome???? 

 

 

my Database is in SQL Server.