Does this have the effect of not creating any statistics for the db and therefore forces queries to FTS rather than use an index?
How can I tell if stats exist for the tables/indexes?
Thanks,
MikeBetter to leave the option as it is by default, and also make sure to run SP_UPDATESTATS to update statistics and also generate DBCC checks to keep up the performance.
Use SP_HELPSTATS to return the information on stats.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment