Basic piece on statistics for queries

  • How statistics are used by the query optimized, how they are stored, some good maintenance practices for users.

  • I'd be interested in taking this. I could write a short piece on viewing statistics and illustrating an example or two as to how they are used.

    From there a quick example on the effects of outdated statistics, and then build a basic script for use in updating statistics regularly so this is never a major problem.

    This could fit into one article, though if you think this sounds hefty, I could split the maintenance into another---but logically I think this all makes sense to be in one place.

  • Sounds good. It's yours.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply