title: How to decrease the search time in Sql Server
body: <p>I have created a windows form that uses SQL Server Database. The windows form contains a search grid which brings all the bank account information of a person. The search grid contains a special field "Number of Account" which displays the number of Accounts a person have associated with a bank. </p>
  
  <p>There are more than 100,000 records in the table from where the data is fetched. I just wanted to know how should I decrease the response time or the search time while getting the data from the table in the search grid. </p>
  
  <p>When I run the page it takes hell lot of time to get the records displayed in the search grid. Moreover, it does not get the data unless and until I provide a search criteria(To and from Date for searching)</p>
  
  <p>Is their any possible way to decrease the search time so that the data should get displayed in the grid.  </p>