I have SQL Server database which has size of 65GB and 6 million rows. We have essays in tables and the average size of an essay is 450 words. When I run a query for the first time, it takes 3-10 seconds to show me the results. On running same query again, it is in less than 1 second (very fast).
Please let me know how to optimize it so I can get queries in less than 1 sec.
SELECT top 1 * FROM tblContent WHERE CONTAINS(pagecontent,'"increasing the likelihood"')
Here is detail of server(VPS):
- OS: Windows Server 2012
- SQL Server 2012 Enterprise (Trial)
- Processor: set to 0
- Memory: set to 0
- RAM: 4GB
- Processor: QUAD 4Ghz