On 04 Mar 2013 13:43, Stone, Joel wrote:
Can you comment on how to determine which indexes I should create
based on the Index Advisor report?
Which columns are most important ie when large values are reported,
these would make a wise index choice?
- "Times advised for query use"?
- "Most expensive query estimate"?
Too long since I have seen that stuff; given my amount of usage and
familiarity with the feature. Sorry, but I pretty much just know
intuitively what to do in most cases, so I tended not to [have to] use
the tooling. There should be some presentations available on the web. I
think mostly they start with getting the most-advised out of the way
first, and then to concentrate on specific queries later.
