I have around 400,000 records in the database. I am using MS SQL 2005
I have created indexes for the required fields in all the tables to which I am joining.
SQL take lot of time to fetch the data sometime around 1.20 min
Can anyone help me that what should I do to retieve data fast.