|
midrange.com
Did manipulating job priorities really help in your case ? It's my
understanding that indexes are built under the MI, where changing job
priorities will have no effect.
-Dave K.
----- Original Message -----
From: "Christen, Duane J." <dchristen@xxxxxxxxxxxxx>
> We have had similar problems with our order system, the users want to sort
> by everything. We did some analysis and determined the top 10 most common
> requested key sets and built the required indexes. Then we built a file
that
> contained the keysets so that we could limit the "un-prepared" queries to
> specific users/groups and to indicate to the users with this capability
that
> they were about to execute a long running query. Later we even changed the
> job priority so that these jobs didn't suck up all of the system resources
> during the query run. (Of course we change the priority back after the
query
> finished)
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
