Database: Sql Server 2016
I have a sql table with a primary key. It has about 15 columns. That table has about 3 million rows in it. Whenever we run Select queries on that table it takes a while to get the results back and some times it causes locks and timeouts, specially if multiple users try to access this table. Any ideas what can be done to optimize and reduce the runtime for select queries on this SQL table?