Don't rely on guess work to determine whether the db uses the index or not. More than likely, if you have index ABC and you search on ABC, the db will not use the index. If you have separate indexes on A and on B and on C, then the db has the choice of which indexes it wants to use.
With Remedy there is no way to pass hints to the db to instruct it to use a given access method, so you have to rely on the mechanism within the db to make the best decision. Unfortunately, this is easier said than done. The db relies on statistics about a table/index/data to determine the best method of access. In oracle terms, this includes statistics collection on the table and the index. Make sure that during your evaluation of how the db works with the indexes that the statistics are in line with what you will have in your production environment. On Oracle, you can evaluate the various options by setting up the indexes/stats as needed, enabling autotrace, then executing your statement. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Thu, Sep 17, 2009 at 9:30 AM, Brittain, Mark <mbritt...@navisite.com> wrote: > ** > Good morning, > > I think I inherited a mess and need some help with indexing. If I have an > index > Status > Assigned Group > Assigned Person > > And the query is Assigned Group and Assigned Person does the index get > ignored because Status was not used? > > What if I have similar indexes like these > > Index 1 > Status > Assigned Group > Assigned Person > > Index 2 > Assigned Group > > Index 3 > Assigned Person > > Are these redundant? > > Also is there and good information out there that really gets into the nuts > and bolts of indexing? > > Thanks > Mark > ____________________________________________ > Mark Brittain > Remedy Developer > NaviSite > mbritt...@navisite.com > (315) 453-2912 x5418 (Phone) > (315) 317.2897 (Cell) > Reduce Cost of IT with Managed Hosting and Application Services from > NaviSite. > Visit www.NaviSite.com Today. > > ________________________________ > This e-mail is the property of NaviSite, Inc. It is intended only for the > person or entity to which it is addressed and may contain information that > is privileged, confidential, or otherwise protected from disclosure. > Distribution or copying of this e-mail, or the information contained herein, > to anyone other than the intended recipient is prohibited. > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
