My teammates and I often have to write queries that revolve around a database that is not partitioned (a single heap file) and has no index. I was told by the DBA that this won't change. Are there techniques we can use that would help us in query performance or is it a it is what it is? For example there is a table that has just north of 54 million rows in it and it takes almost 40 seconds to get the answer to
select count(*) from dbo.table
This is in SSMS.
Queries against these tables coming back with maybe 2,000 records with simple filters of
columnA = 'this' and date is >= 'this date' take a few minutes.