database will flooded with GBs of data in each day .i used to archive data in day wise.

The actual problem is when querying some thing from huge data , to show it on a web page. then there the problem. Query time out occurs.

i used indexing .

I felt the query execution will be slower in querying for some data.?