On DB2 there was a command called runstats() whichi made sured index tables etc were up to date. Is there an equivalent in SqlServer?
Also, if I have a very large table that gets a reasonable amount of use, is there any sort of periodic health cleaning I should do. For example, on my PC, every now and again I defrag the disk. And equivalent for a specific SQL table?