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.
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
This mailing list archive is Copyright 1997-2013 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact