Indexes - is EXEC sp_updatestats sufficient?
Posted on 2014-03-13
I have a large couple of tables which are constantly growing
I need to increase performance as the speeds accessing data are slow
I try and run EXEC sp_updatestats whenever i can
Does this create indexes, and will it help with performance
If not, please can someone help me with the code to run to create indexes?
version: SQL server 2012 business intelligence
The specs are currently quite low, and we plan to upgrade in future, but its a dedicated DB server VM, with 1GB ram (I KNOW!) intel xenon quade core 2.5GHZ CPU
Running on win 2008 R2
I need to squeeze as much performance as possible out of it