Hi, Would like to help some opinions.. I got a database that is recently increasing in size. My window application use SELECT query with inner join of different tables. Now the execution of this query is getting slower due to more and more records. I got three ideas to speeding the process.. 1) Create a View table 2) Create Indexes for each tables 3) Create Stored Procedure Which one will be a better choice?